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 responses

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!
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