Drop Down List

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You could use format|conditional formatting on the cell that contains the value.
 
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.
 
Back
Top