Conditional Formatting Tab Locked

  • Thread starter Thread starter WOODY
  • Start date Start date
W

WOODY

Hi All

I have formatted a spreadsheet I use daily using the conditional formatting
options and for some reason the tab is now greyed out so I can't get back to
the format options I have selected for the spreadsheet. I need to change some
of the things I had originally setup. Does anyone know why the tab would be
locked out or how I could get it unblocked?

Thanks
 
Either the worksheet is protected or the workbook is shared. Both of those
lock out CF.
 
Do you have more than one sheet selected?

Is the sheet protected?

Is the workbook shared?


Gord Dibben MS Excel MVP
 

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

Similar Threads

Conditional formating is greyed out and unavailable 2
Conditional Formatting option not available 6
Why is conditional formatting disabled(!)? 3
conditional formatting - copy format & remove condition 1
Conditional Formatting Help 3
Way to find if conditional formatting triggered? 1
Sorting Cells with Conditional Formats 1
Cell shading with conditional formatting 5

Back
Top