You could just add a helper column that tests the same condition as the CF,
and this will show TRUE or FALSE. If filtered, it only shows visible cells
anyway.

--

HTH

RP

"Gareth" wrote in message
...
Is it possible to check all VISIBLE rows on all VISIBLE sheets in a file
to
see if there any cells with conditional formatting in them.

I use cond. formatting as follows:

Formula Is =H7="" and a color would be applied to the cell if it was blank
(34). I want to check all visible sheets and visible rows in those sheets
for any empty cells with this cond. format.

Hope this makes sense.

Your help much appreciated as usual.

Gareth