[doss04]

I would like to have a cell change color according to the word used in the
drop down list. (ie) drop down list has CLEAR (which would be green), CAUTION
(which would be yellow), and DANGER (which would be red). Anyone have any
ideas?

[Max]

Assuming the droplists are in A1 down,
and you want to conditionally format col B

Select col B (B1 active), then apply the CF using Formula Is:
Condition1: =A1="Clear"
Format Green
Condition2: =A1="Caution"
Format Yellow
Condition3: =A1="Danger"
Format Red
Click to OK out

And if you want the CF to apply to col A,
just select col A, then apply exactly as above (no change)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
"doss04" wrote:
I would like to have a cell change color according to the word used in the
drop down list. (ie) drop down list has CLEAR (which would be green), CAUTION
(which would be yellow), and DANGER (which would be red). Anyone have any
ideas?

[Joerg Mochikun]

First use Data = Validation to create the dropdown list. Then use Format =
Conditional Formatting to set the colors for each entry.

Joerg

"doss04" wrote in message
...
I would like to have a cell change color according to the word used in the
drop down list. (ie) drop down list has CLEAR (which would be green),
CAUTION
(which would be yellow), and DANGER (which would be red). Anyone have any
ideas?