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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locate Conditional Formatting 1
- Thread starter chew1920
- Start date
Code:
worksheets(1).range("A1").FormatConditions(1).typewill 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.
-
1
- #3
- Status
Similar threads
