Use DataValidation, and create a List with those values.

--
HTH

Bob Phillips

"shezzer_1972" wrote in message
...
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.