Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colorful Dropdown Lists
Hi,
I've seen it in other sheets but can't figure out how to create one. I'm trying to create a dropdown list that changes color whit each selection. For instance, Pass = Green, Fail = Red and Not Executed = Yellow. I'm able the create the dropdown list and put it in the cell but can't seem to give it color. Does anyone know how? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colorful Dropdown Lists
I'm assuming that you created the dropdown list via data|validation.
Look at Format|Conditional formatting. This won't shade the options, but it will shade the cell after you've updated the cell. creative schwabbie wrote: Hi, I've seen it in other sheets but can't figure out how to create one. I'm trying to create a dropdown list that changes color whit each selection. For instance, Pass = Green, Fail = Red and Not Executed = Yellow. I'm able the create the dropdown list and put it in the cell but can't seem to give it color. Does anyone know how? Thanks! -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Colorful Dropdown Lists
The coloring effect can be achieved via applying conditional format on the DV
cells. Assume your DV list is applied to col A. Select col A (A1 active), click Format Cond Formatting, and apply it as: Condition 1, Formula is: =A1="Pass" Format: Green fill Condition 2, Formula is: =A1="Not Executed" Format: Yellow fill Condition 3, Formula is: =A1="Fail" Format: Red fill Click to OK out -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "creative schwabbie" wrote: Hi, I've seen it in other sheets but can't figure out how to create one. I'm trying to create a dropdown list that changes color whit each selection. For instance, Pass = Green, Fail = Red and Not Executed = Yellow. I'm able the create the dropdown list and put it in the cell but can't seem to give it color. Does anyone know how? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown lists | Excel Worksheet Functions | |||
Dropdown Lists | Excel Discussion (Misc queries) | |||
Dropdown Lists... | Excel Discussion (Misc queries) | |||
continuing dropdown lists | Excel Worksheet Functions | |||
Dropdown lists | Excel Discussion (Misc queries) |