| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing entire row based on 1 MAX cell value (Conditional Formatt | Excel Worksheet Functions | |||
| Creating a macro to formatt data | Excel Programming | |||
| HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT | Excel Worksheet Functions | |||
| Counting cells with Invalid Data | Excel Programming | |||
| Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
Linear Mode
