View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Conditional Formatting Tab Locked

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

Jim Thomlinson


"WOODY" wrote:

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