from the menu bar, pick Format / Conditional Formatting...

"Ayd" wrote:

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