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?