Conditional formatting excel drop down list

[Closed]
Report
Posts
2
Registration date
Sunday March 16, 2014
Status
Member
Last seen
March 16, 2014
-
Posts
2
Registration date
Sunday March 16, 2014
Status
Member
Last seen
March 16, 2014
-
Hello,

I want to color code a drop down list in excel? I have done conditional fomatting on each cell in the list, it is a text list, but not working

2 replies


Dearest member, I am confused with your query.

The list will not turn colors, as described. If this is not what you are meaning, then please let us know more detials, please.

Thank you! Have Fun!
Posts
2
Registration date
Sunday March 16, 2014
Status
Member
Last seen
March 16, 2014

Correct, if I have 3 options

Complete
Not Complete
At Risk

I want complete- blue, not complete, red, and at risk orange. I can do the drop down list, no problem, but changing the colors to appear with the drop down list is the problem