Conditional Format - greyed out?

  • Thread starter Thread starter NICGRANT
  • Start date Start date
N

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?
 
It is probably a shared workbook, there is much functionality not available
in shared workbooks.
 
Hi,

2 Possibilities.

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

Mike
 
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.
 
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.
 
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.
 
Back
Top