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.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017