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

's Computer Specifications

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?

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing entire row based on 1 MAX cell value (Conditional Formatt	SunshineinFt.Myers	Microsoft Excel Worksheet Functions	2	24th Feb 2009 05:18 PM
A macro that counts cells when the conditional formatting formula =True. i.e. the cell is colored other than white.	R Tanner	Microsoft Excel Programming	5	19th Jun 2008 09:16 AM
HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT	=?Utf-8?B?Y29uZGl0aW9uYWwgZm9ybWF0?=	Microsoft Excel Worksheet Functions	2	30th Jul 2006 05:37 PM
Cell Format Changes When Data Is Entered - Not Conditional Formatt	=?Utf-8?B?U3VuZGFuY2VLaWRMdWR3aWc=?=	Microsoft Excel Worksheet Functions	2	30th Sep 2005 02:07 PM
formatt cells	tmarta	Microsoft Excel New Users	2	7th Mar 2004 05:49 PM