use color coded data on a drop down validated list

[Irene]

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]

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 here:

http://www.contextures.com/xlCondFormat01.html