| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Data Validation status via a macro
Since I cannot run a macro to query cell(s) for Conditional Formatting
results, can I query for Data Validation results? I have 40+ sheets in my workbook and I would like to set the Sheet Tab colors to indicate whether a sheet has out of limit data in any cell on the sheet. Thank you for your help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check Data Validation status via a macro
hi, !
Since I cannot run a macro to query cell(s) for Conditional Formatting results can I query for Data Validation results? I have 40+ sheets in my workbook and I would like to set the Sheet Tab colors to indicate whether a sheet has out of limit data in any cell on the sheet. IF... you (dare to) read the (whole) suggested link in your previous post... you will see that you CAN do query cell(s) for conditional formatting results -?- hth, hector. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB Data Validation check | Excel Discussion (Misc queries) | |||
| Verify data validation status inside VBA | Excel Programming | |||
| Macro Forces a Check of Data Validation Before Saving or E-mailing | Excel Programming | |||
| Check Boxes & Data Validation | Excel Discussion (Misc queries) | |||
| Data Validation to check Dynamic range in another sheet | Excel Programming | |||
Linear Mode
