Check Data Validation status via a macro

  • Thread starter Thread starter JudgeMental
  • Start date Start date
J

JudgeMental

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.
 
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.
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Link to Color Coating 1
Macro to Combine Data from Multiple Sheets with Cell References 4
execute assigned data validation in vba? 11
Return cell(s) Conditional Formatting Status via a macro 3
Error Message - Macro to Unlink MS Queries from Workbook 0
Macro for checking data in a cell against another cell andcopying/pasting data 8
Excel Move or Copy Stopped Working? 0
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2

Back
Top