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.