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

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?

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

On the edit menu of the spreadshbeet is the "Go to". You can find
conditional formating using the Go To

"Dave L" wrote:

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?