Finding data validation and conditional formatting

D

Dave L

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?
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top