A
Ayd
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
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