Finding data validation and conditional formatting
 

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?

Finding data validation and conditional formatting
 

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.

Dave L wrote:

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