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?