| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use color coded data on a drop down validated list
Hi,
I have a drop down list as: Continuing (black) Completed (color blue) Terminate (color red) I color coded it so i can easily tell which is which, but how can i have my drop down list to be color coded too? Would appreciate any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
use color coded data on a drop down validated list
You can't colour code the items in a data validation drop down list.
After an item has been selected, you could use conditional formatting in the cell, to colour the selected item. There are instructions he http://www.contextures.com/xlCondFormat01.html Irene wrote: Hi, I have a drop down list as: Continuing (black) Completed (color blue) Terminate (color red) I color coded it so i can easily tell which is which, but how can i have my drop down list to be color coded too? Would appreciate any help. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color coded bar chart | Charts and Charting in Excel | |||
| Sum Color coded cells | Excel Worksheet Functions | |||
| Concatenate Results from a Validated Drop Down List | Excel Discussion (Misc queries) | |||
| Can you sort excel data by color coded cells? | Excel Discussion (Misc queries) | |||
| How to validate data in already list dropdown validated. | Excel Discussion (Misc queries) | |||
Linear Mode
