Conditional Format search and retrieve
Hi everyone,
Does anyone know of a search function that wil "find all" cells that contain
conditional formats?
I recorded a macro that came up with this useful code
ActiveCell.SpecialCells(xlCellTypeAllFormatConditi ons).Select
This selects them all as you would expect.
I want to step through each cell that has Conditional Formatting and pick up
the formula beneath it that performs the format. Is this possible?
Much obliged for any help!
Bony
|