Formatting (conditional?) a drop down box selection

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

Guest

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
 
Try this:

Assume cell A1 contains the drop down.

Select cell A1
Goto the menu Format>Conditional 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
 
Assuming the dropdown is a Data Validation list dropdown.

Select the cell and Format>Conditional 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
 
Back
Top