| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell color from drop down list
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change color of Drop Down List (Validation box) | Setting up and Configuration of Excel | |||
| drop down list that changes cell color upon selection | Excel Discussion (Misc queries) | |||
| color options from drop down list | Excel Discussion (Misc queries) | |||
| How do I color code items in a drop down list? | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Threaded Mode
