2007 excel options 'greyed out'

Hi all,

I seem to have a problem and not sure how to rectify,

I am trying to do some 'conditional formatting' but the option to select
this in the tool bar is 'greyed out' and am unable to select and use.

I am not sure why this has happened as it originally worked when i created
the workbook.

Thanks in advance,

Aaron

Hi,

Make sure you are not in Edit mode. Make sure you only have one sheet
selected. Protection is off.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Aaron Hodson (Coversure)" wrote:

Hi all,

I seem to have a problem and not sure how to rectify,

I am trying to do some 'conditional formatting' but the option to select
this in the tool bar is 'greyed out' and am unable to select and use.

I am not sure why this has happened as it originally worked when i created
the workbook.

Thanks in advance,

Aaron

Hi,

and add to my previous - the workbook is not shared.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Aaron Hodson (Coversure)" wrote:

Hi all,

I seem to have a problem and not sure how to rectify,

I am trying to do some 'conditional formatting' but the option to select
this in the tool bar is 'greyed out' and am unable to select and use.

I am not sure why this has happened as it originally worked when i created
the workbook.

Thanks in advance,

Aaron