You can't colour code the items in a data validation drop down list.
After an item has been selected, you could use conditional formatting in
the cell, to colour the selected item.
There are instructions he
http://www.contextures.com/xlCondFormat01.html
Irene wrote:
Hi,
I have a drop down list as:
Continuing (black)
Completed (color blue)
Terminate (color red)
I color coded it so i can easily tell which is which, but how can i have my
drop down list to be color coded too?
Would appreciate any help.
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com