Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colored dropdown list
I'm looking to construct a dropdown with values, say, 'hot', 'warm',
'cool' where each of those options have individually colored background. When selected, the color in the cell or widget background should stick'. Can this be done please? Thanks - Lynn. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colored dropdown list
Can easily be accomplished using a combination of "Conditional Formatting"
and "Data Validation" in the same cell. Check out the Help files. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Lynn. Rickards" wrote in message ups.com... I'm looking to construct a dropdown with values, say, 'hot', 'warm', 'cool' where each of those options have individually colored background. When selected, the color in the cell or widget background should stick'. Can this be done please? Thanks - Lynn. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colored dropdown list
Lynn,
RagDyeR is suggesting using Data Validation (allow = list, source = cold,warm,hot ). You won't get to see the background on the dropdown. I don't see that there is an easy way to do that. Once the user has selected from this validation list, RagDyeR is suggestion using Format Conditional Formatting to set the colours. You want to set it like this: 1. cell value is ... equal to ... cold , choose FORMAT PATTERN blue background. Maybe also choose a white font. Add 2. cell value is ... equal to ... warm, choose FORMAT PATTERN orange background Add 3. cell value is ... equal to ... hot, choose FORMAT PATTERN red background. Choose a white font as well. HTH -- Allllen "RagDyeR" wrote: Can easily be accomplished using a combination of "Conditional Formatting" and "Data Validation" in the same cell. Check out the Help files. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Lynn. Rickards" wrote in message ups.com... I'm looking to construct a dropdown with values, say, 'hot', 'warm', 'cool' where each of those options have individually colored background. When selected, the color in the cell or widget background should stick'. Can this be done please? Thanks - Lynn. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I remove a dropdown list from my worksheet | Excel Discussion (Misc queries) | |||
Preventing manual entry in dropdown list ... possible? | Excel Discussion (Misc queries) | |||
How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
Entering data from dropdown list | Excel Discussion (Misc queries) | |||
HELP! Nesting IF Statements/Dependent Dropdown List | Excel Worksheet Functions |