Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formating is greyed out and unavailable
I have an Excel spreadsheet that already has a lot of conditional formating.
However, when I now try to add conditional formating to another cell the conditional formating option is greyed out. Nothing is locked or protected on this spreadsheet, and I don't understand what caused this change. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formating is greyed out and unavailable
If nothing is locked or protected then perhaps the workbook is shared.
ToolsShare Workbook. Uncheck "allow changes etc." Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 09:51:03 -0700, Strider wrote: I have an Excel spreadsheet that already has a lot of conditional formating. However, when I now try to add conditional formating to another cell the conditional formating option is greyed out. Nothing is locked or protected on this spreadsheet, and I don't understand what caused this change. Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formating is greyed out and unavailable
Thanks, Gord! That did it. I thought the spreadsheet was no longer shared,
but after your reply I checked again and saw that it was. "Gord Dibben" wrote: If nothing is locked or protected then perhaps the workbook is shared. ToolsShare Workbook. Uncheck "allow changes etc." Gord Dibben MS Excel MVP On Thu, 5 Oct 2006 09:51:03 -0700, Strider wrote: I have an Excel spreadsheet that already has a lot of conditional formating. However, when I now try to add conditional formating to another cell the conditional formating option is greyed out. Nothing is locked or protected on this spreadsheet, and I don't understand what caused this change. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|