Conditional Formatting while sharing document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
No workaround except unshare the workbook.

Shared workbooks have many limitations.

See Help>share>Features that are unavailable in shared workbooks

Why is this the case?

Only the developers know for sure.


Gord Dibben MS Excel MVP
 
Thanks for your help! I really appreciate it : )

Gord Dibben said:
No workaround except unshare the workbook.

Shared workbooks have many limitations.

See Help>share>Features that are unavailable in shared workbooks

Why is this the case?

Only the developers know for sure.


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top