Check Conditional formatting in 2007
 

In Excel 2003 there is a way to cause all conditionally formatted cells to
highlight in gray. It's to check if you've formatted all the intended cells
without missing any. However I'm not sure how to do that in the 2007
version. Anyone know what I'm talking about?

--
thanks in advance!

Check Conditional formatting in 2007
 

I don't know how you did it in Excel 2003 but this will do it in any
version:

Hit function key F5
SpecialConditional formatsOK

--
Biff
Microsoft Excel MVP


"COB" wrote in message
...
In Excel 2003 there is a way to cause all conditionally formatted cells to
highlight in gray. It's to check if you've formatted all the intended
cells
without missing any. However I'm not sure how to do that in the 2007
version. Anyone know what I'm talking about?

--
thanks in advance!