Check Data Validation status via a macro

's Computer Specifications

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.

's Computer Specifications

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.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VB Data Validation check	Bony Pony	Microsoft Excel Misc	1	8th Oct 2009 02:46 PM
Check Refresh Status of External Data Query	Mark	Microsoft Excel Programming	0	15th Mar 2009 09:41 PM
Verify data validation status inside VBA	=?Utf-8?B?QWxleCBTdC1QaWVycmU=?=	Microsoft Excel Programming	1	31st Jan 2007 02:05 AM
Macro Forces a Check of Data Validation Before Saving or E-mailing	=?Utf-8?B?amJ0ZW5vcjE=?=	Microsoft Excel Programming	0	23rd Jan 2006 05:02 PM
When pasting data into a column with data validation I lose validation check	Brad	Microsoft Excel Misc	5	17th Apr 2004 01:11 PM