Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting while sharing document
Hey everyone
The document I am working with is a Shared document and Excel does not seem to permit Conditional Formatting for Shared documents (the menu option is greyed out, and when I removed the document sharing the option became available). Do you know why this is the case? Is there any way I can work around this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting while sharing document
No workaround except unshare the workbook.
Shared workbooks have many limitations. See HelpshareFeatures that are unavailable in shared workbooks Why is this the case? Only the developers know for sure. Gord Dibben MS Excel MVP On Tue, 16 Oct 2007 08:41:02 -0700, SK wrote: Hey everyone The document I am working with is a Shared document and Excel does not seem to permit Conditional Formatting for Shared documents (the menu option is greyed out, and when I removed the document sharing the option became available). Do you know why this is the case? Is there any way I can work around this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Series Formatting changes when I save and reopen a document | Charts and Charting in Excel | |||
Broken formatting while pasting document | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |