Conditional Formatting Tab Locked

**Woody** · October 6th, 2009, 03:51 PM posted to microsoft.public.excel.misc

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** · October 6th, 2009, 04:35 PM posted to microsoft.public.excel.misc

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

**Gord Dibben** · October 6th, 2009, 04:36 PM posted to microsoft.public.excel.misc

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode