Try conditional programing.

"shezzer_1972" wrote:

I want to create a drop down list in excel whereby the user chooses an
option. This list is a status list so is it possible to code it so that they
can select RED, AMBER, or GREEN but the cell is coloured in the corresponding
colour. When I have tried it just appears as the words.