Or else the file is shared, in which case you also cannot use conditional
formatting. If true, you will have to remove the sharing, before using it.

"Randy" wrote:

It sounds like the sheet is protected. Unprotecting the
sheet should enable the Conditional Formatting.


-----Original Message-----
I have used conditional formatting on some spreadsheets,
so I know how to use
it. My problem is that on other spreadsheets I cannot
choose it from the
Format Menu. The Conditional Formatting choice is
lightly shaded. Why is
this and how can I fix it.
.