| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
| Formatting of cells in a locked worksheet. EG shading | Excel Worksheet Functions | |||
| Can the conditional format box be locked to the cell | Excel Worksheet Functions | |||
| Locked Formatting | Excel Discussion (Misc queries) | |||
| Locked out of Cell Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
