Conditional Formatting Tab Locked

[WOODY]

Hi All

I have formatted a spreadsheet I use daily using the conditional formatting
options and for some reason the tab is now greyed out so I can't get back to
the format options I have selected for the spreadsheet. I need to change some
of the things I had originally setup. Does anyone know why the tab would be
locked out or how I could get it unblocked?

Thanks

 

[Jim Thomlinson]

Either the worksheet is protected or the workbook is shared. Both of those
lock out CF.

 

[Gord Dibben]

Do you have more than one sheet selected?

Is the sheet protected?

Is the workbook shared?


Gord Dibben MS Excel MVP