Conditional formatting excel drop down list

Closed
tch1908
Posts
2
Registration date
Sunday March 16, 2014
Status
Member
Last seen
March 16, 2014
- Mar 16, 2014 at 06:36 PM
tch1908
Posts
2
Registration date
Sunday March 16, 2014
Status
Member
Last seen
March 16, 2014
- Mar 16, 2014 at 07:53 PM
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

Blocked Profile
Mar 16, 2014 at 07:49 PM
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!
0
tch1908
Posts
2
Registration date
Sunday March 16, 2014
Status
Member
Last seen
March 16, 2014

Mar 16, 2014 at 07:53 PM
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
0