Debra

fantastic, this was really really helpful and the instructions helped it to
click for me! thanks to all who responded and a BIG THANK you to you from me!

"Debra Dalgleish" wrote:

Use Data Validation to create a dropdown list of colours (as words).
There are instructions in Excel's Help, and he

http://www.contextures.com/xlDataVal01.html

Then, use conditional formatting to colour the cell based on the word
that was selected. There are instructions in Excel's Help, and he

http://www.contextures.com/xlCondFormat01.html

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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html