Conditional Format - greyed out?

[NICGRANT]

Please can someone help me - I have a spreadsheet which I have "inherited"
and trying to add Conditional formatting to a cell, the CF menu selection is
greyed out. Any thoughts why?

 

[Bob Phillips]

It is probably a shared workbook, there is much functionality not available
in shared workbooks.

 

[Mike H]

Hi,

2 Possibilities.

1. is the worksheet protected? If it is un-protect.
2. is the workbook shared?. If it is un-share.

Mike

 

[NICGRANT]

Appreciated - it was a shared w/book. Un-sharing released it.
Thanks

 

[Martin Hanson]

Both Conditional Formating and Format as Table are greyed out on my workbook.
The workbook had conditionally formatted cells that need to be corrected. I
beleive it was opened in 2003 and saved in 2003 then I have opened it in 2007
SP2.

The workbook is NOT SHARED and is NOT PROTECTED.

How can I get back to the conditional formatting I need to change?

Thank you.

 

[Martin Hanson]

Both Conditional Formating and Format as Table are greyed out on my workbook.
The workbook had conditionally formatted cells that need to be corrected. I
beleive it was opened in 2003 and saved in 2003 then I have opened it in 2007
SP2.

The workbook is NOT SHARED and is NOT PROTECTED.

How can I get back to the conditional formatting I need to change?

Thank you.

 

[Martin Hanson]

Found the problem; I had multiple worksheets selected becusae I was trying to
conditional format cells on multiple worksheets--apparently that doesn't
work. I will try copying them and then pasting them 3D into the other
worksheets.