Check Conditional formatting in 2007

C

COB

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?
 
T

T. Valko

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

Hit function key F5
Special>Conditional formats>OK
 
Top