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.