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.