Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |