Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add separate colors to values in drop down list
How would I associate separate colors to each of the values in my drop down
list so that when I choose the value, the color shows for the selection? In process (yellow); Completed (green), Never Started (Red), Follow Up (Blue). Thank you in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add separate colors to values in drop down list
Use conditional formatting. See
http://www.contextures.com/xlCondFormat01.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "vlwilburn" wrote in message ... How would I associate separate colors to each of the values in my drop down list so that when I choose the value, the color shows for the selection? In process (yellow); Completed (green), Never Started (Red), Follow Up (Blue). Thank you in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add separate colors to values in drop down list
Thank you, this site truly helped and will be helpful in the future with
another project. Appreciate your quick response. "Bob Phillips" wrote: Use conditional formatting. See http://www.contextures.com/xlCondFormat01.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "vlwilburn" wrote in message ... How would I associate separate colors to each of the values in my drop down list so that when I choose the value, the color shows for the selection? In process (yellow); Completed (green), Never Started (Red), Follow Up (Blue). Thank you in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add separate colors to values in drop down list
One thing I did forget to ask. In a drop down list like this I know you can
have more than three, but is there a way of overriding the Conditional Formating to add more conditions, i.e. (4 or 5)? "Bob Phillips" wrote: Use conditional formatting. See http://www.contextures.com/xlCondFormat01.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "vlwilburn" wrote in message ... How would I associate separate colors to each of the values in my drop down list so that when I choose the value, the color shows for the selection? In process (yellow); Completed (green), Never Started (Red), Follow Up (Blue). Thank you in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add separate colors to values in drop down list
You can either us VBA or this
http://www.xldynamic.com/source/xld.....Download.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "vlwilburn" wrote in message ... One thing I did forget to ask. In a drop down list like this I know you can have more than three, but is there a way of overriding the Conditional Formating to add more conditions, i.e. (4 or 5)? "Bob Phillips" wrote: Use conditional formatting. See http://www.contextures.com/xlCondFormat01.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "vlwilburn" wrote in message ... How would I associate separate colors to each of the values in my drop down list so that when I choose the value, the color shows for the selection? In process (yellow); Completed (green), Never Started (Red), Follow Up (Blue). Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Values from 3 separate drop-down lists entered into single cell | Excel Worksheet Functions | |||
Can I have assorted colors on list in a drop down box in Excel? | Excel Discussion (Misc queries) | |||
How to create a drop down list with different values | New Users to Excel | |||
Drop down list with different values. | Excel Worksheet Functions | |||
Validation Tables For Drop Down list on a Separate Worksheet. | Excel Worksheet Functions |