format choices in data validation

B

Bill

I want to format the choices in a data validation, such
that mylist is the list of values, and I want to format
these such that value1 is a blue backgroung, value 2 is
yellow and value 3 is green. I want the data validation
drop down list to also be coloured, or a different font to
make it easy for the choice.

Can this be done?
 

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List 1
xls data validation question 2 2
Data Validation 3
Data Validation Question 4
Using coloured text within a Validation List 1
Data Validation Formulas 4
Data Validation with dynamic ranges 2

Top