I want to create a drop down box with three choices High, Medium, Low. When
high is selected I would like the cell to turn red, when Medium is selected
turn yellow and Low would be green. Can't figure out how to get this done.

Data/Validation: Select List, Type in
High,Medium,Low as the list (no quotes anywhere)
With the same cell(s) selected, use Format/Conditional Formatting
Change "between" to Equal, type the word High (no quotes needed), click
Format, Select Patterns tab, choose Red.
Click OK back to the formatting options, click Add, repeat process for
Medium & Low & use yellow then green.
HTH

"Judithj" wrote in message
...
I want to create a drop down box with three choices High, Medium, Low. When
high is selected I would like the cell to turn red, when Medium is
selected
turn yellow and Low would be green. Can't figure out how to get this done.

Try this:

Assume cell A1 contains the drop down.

Select cell A1
Goto the menu FormatConditional Formatting

Condition 1
Formula Is: =A1="High"
Click the Format button
Select the Pattern tab
Select RED
OK

Click the Add button

Condition 2
Formula Is: =A1="Medium"
Click the Format button
Select the Pattern tab
Select YELLOW
OK

Click the Add button

Condition 3
Formula Is: =A1="Low"
Click the Format button
Select the Pattern tab
Select GREEN
OK out

Biff

"Judithj" wrote in message
...
I want to create a drop down box with three choices High, Medium, Low. When
high is selected I would like the cell to turn red, when Medium is
selected
turn yellow and Low would be green. Can't figure out how to get this done.

Assuming the dropdown is a Data Validation list dropdown.

Select the cell and FormatConditional Formatting.

You are allowed 3 formats(4 if you count default).

Cell value = "low"

Call value = "medium"

Cell value = "high"

Format each condition to your color of choice.


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 13:04:00 -0700, Judithj
wrote:

I want to create a drop down box with three choices High, Medium, Low. When
high is selected I would like the cell to turn red, when Medium is selected
turn yellow and Low would be green. Can't figure out how to get this done.