Conditional Formatting, how can you check full?

  oo7juk 10:22 27 Feb 07


I have a workbook that has conditional formatting applied to the columns but when I was updating sheet one of the cells didn't highlight change. Rather than go through every cell manually is there a way of checking whole sheet so that I can identify cells with no formatting and then correct.

I tried options/view formulas

Many thanks.

  VoG II 10:35 27 Feb 07

Edit > Goto > Special > Conditional Formats.

  oo7juk 12:28 28 Feb 07

Many thanks Vog.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…