Conditional formating is greyed out and unavailable

S

Strider

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?
 
G

Gord Dibben

If nothing is locked or protected then perhaps the workbook is shared.

Tools>Share Workbook. Uncheck "allow changes etc."


Gord Dibben MS Excel MVP
 
S

Strider

Thanks, Gord! That did it. I thought the spreadsheet was no longer shared,
but after your reply I checked again and saw that it was.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top