Drop Down List

[Guest]

I have created a drop down list with three options in it. Hot, Warm, and Cold I would like each to appear as a differen
color when choosen. either the text or the box it does not matter. Does anyone know if this is possible to do?

 

[Dave Peterson]

You could use format|conditional formatting on the cell that contains the value.

 

[Guest]

Could you give an example of how you would do this

 

[Dave Peterson]

Select the cell
Format|conditional formatting.
cell value "is equal to" Hot
(format as desired)

Click Add
Cell value "is equal to" Warm
(and format as desired)

and the same for Cold.

And without any other restrictions, I think I'd use Data|Validation to create
that dropdown effect.