View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gareth[_3_] Gareth[_3_] is offline
external usenet poster
 
Posts: 109
Default Conditional Formatting

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