| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting (conditional?) a drop down box selection
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create new drop down from previous drop down selection | Excel Discussion (Misc queries) | |||
| How to 'copy' a drop down box selection? | Excel Discussion (Misc queries) | |||
| XL2K - Conditional Formatting relative to cell selection | Excel Discussion (Misc queries) | |||
| drop down selection determines other drop down content | Excel Discussion (Misc queries) | |||
| Conditional Formatting and selection | Excel Discussion (Misc queries) | |||
Hybrid Mode
