Only the value will come through from the validation list and not the colour.
To make the colour change will require conditional formatting.
--
HTH...

Jim Thomlinson


"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