View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bony Pony[_2_] Bony Pony[_2_] is offline
external usenet poster
 
Posts: 71
Default 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