How do I find cells with invalid data and true conditional formatt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a rather large spreadsheet (about 150 columns and 14,000 rows) that
I've written a macro on to use validation and conditional formatting based on
certain rules. The problem is that it's hard to find the cells that get
highlighted by the formatting or circle by the validation due to the large
size of the spreadsheet. Is there a way to find those cells without having to
scroll for them?
 
I have a rather large spreadsheet (about 150 columns and 14,000 rows) that
I've written a macro on to use validation and conditional formatting based on
certain rules. The problem is that it's hard to find the cells that get
highlighted by the formatting or circle by the validation due to the large
size of the spreadsheet. Is there a way to find those cells without having to
scroll for them?
Click to expand...
 

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

Similar Threads

Find/Filter highlighted cells 1
Finding data validation and conditional formatting 1
Invalid Circles - Can I force their display? 5
recognizing conditional formatting with VBA 3
VB Data Validation check - apologies for incorrect post 2
Conditional Formatting macro: simple, but doesn't work 6
Data Validation circle cell position 1
Code to show if a cell has met conditional formatting 6

Back
Top