Locate Conditional Formatting 1

[chew1920]

Is there a way in excel 2003 to locate all cells that contain conditional formatting? I have an inherited spreadsheet that has about 300 rows by 13 columns with varying levels of conditional formatting. Is there an easy way to find all of those cells without going one by one? Also is there a programmatic way to set conditional formatting?

 

[mintjulep]

worksheets(1).range("A1").FormatConditions(1).type

will return a number if there is conditional formatting for cell A1, or an error if there is not.

You can programatically set conditional formatting using the Application Property, Borders Property Creator Property Font Property Formula1 Property Formula2 Property Interior Property
Operator Property Parent Property Type Property

of the FormatConditions object.

 

[combo]

To select cells with conditional formatting:
Edit>Go to, 'special' button, and select 'conditional formatting'.

combo