Conditional Formatting Tab Locked
 

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

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

Conditional Formatting Tab Locked
 

Do you have more than one sheet selected?

Is the sheet protected?

Is the workbook shared?


Gord Dibben MS Excel MVP

On Tue, 6 Oct 2009 07:51:01 -0700, 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