Data Validation with colour

I

ianripping

Is it possible to have Data validation for a list of values but add
colour to a selection of them?

At the moment they change back to the default colour?

May be an IF Command

Like IF = 6 THEN RED
 
C

Chip Pearson

I'm not exactly sure what your question is, but you might be able
to use Conditional Formatting from the Format menu to accomplish
what you want.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top