Conditional Formatting, how can you check full?

  oo7juk 10:22 27 Feb 2007


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 2007

Edit > Goto > Special > Conditional Formats.

  oo7juk 12:28 28 Feb 2007

Many thanks Vog.

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

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

The secrets of creating gory VFX

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache