Data Validation

[Nine Zero]

I have a data validation drop down list with several entries.

How can i also transfer the formatting over of the options from the list

Example, if in my list i have an option that says USA and it is highlighted red i would like to also have the list appear red when i select USA

Hope this makes sense....if more clarification is needed please let me know

thank you

 

[Truiz]

Have you tried using conditional formatting?

Check Tip 3 of this Guide