How do I get drop down menu's to show different background colour
I am trying to create a drop down list of options using data Validation in
Excel 2003. I have set it up fine, but want the results to show the
background colour that I have selected for them.
For example, if option 1 is selected, the cell would turn green, option 2,
blue, etc.
Is this possible, and if so, how, as my list will currently only display the
text, and no colour?
Kind regards
|