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