Conditional Formatting Tab Locked

W

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
 
J

Jim Thomlinson

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

Gord Dibben

Do you have more than one sheet selected?

Is the sheet protected?

Is the workbook shared?


Gord Dibben MS Excel MVP
 
Top