I'm using a data validation list and i'd like to have the cell obtain all the charecteristics (not just the value) of the selection from the list.
i.e. If the list is composed of the values one, two and three. If a user selects "one" the word "one" appears in the cell and the colour turns to red. Pick two and "two" appears in green cell. ...
Can this be done?
How would I go about doing this?
Thanks in advance for your help