Finding data validation and conditional formatting

[Guest]

Hi All,
I've written a macro for a rather large spreadsheet (about 150 rows and
20,000 columns) that applies data validation and conditional formatting to
look for data entry that doesn't meet certain sets of conditions. What I want
to know is if there is a way to find cells where the conditional formatting
has returned true, thus highlighting the cell, without having to scroll
through the wntire sheet. Likewise I would like to know if there is a faster
way to find cells that have data that is invalid. I know that you can find
cells that contain conitional formatting and data validation, but in my case
all of the cells contain these. Any ideas?

 

[Dave Peterson]

I don't know a way to look at the conditional formatting rules except to look at
each cell and try to evaluate the CF formula.

Chip Pearson has some code that may help you:
http://cpearson.com/excel/CFColors.htm

The second question deals with invalid data in cells with data|validation?

If yes, you can show the Formula auditing toolbar and click the "circle invalid
data" icon.