Is it possible to have each value in a dropdown list box with its own background color?
For example, a dropdown contains 2 values: "Good" and "Bad". I want high to display "Good" with a background color of geen,and "Bad" with a background color of red. I tried using conditional formatting, but this changes the background of all values in the control. I'm trying to avoid using code if at all possible.
Thanks.