How do I get a list to display colours

[shezzer_1972]

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.

 

[Bob Phillips]

Use Data>Validation, and create a List with those values.

 

[bj]

Try conditional programing.

 

[shezzer_1972]

Hi,

wow thanks for the fast reponses. I tried both those options and couldn't
get it to work, it just displayed again the list as words and not colours...,
any other thoughts? appreciate your responses

 

[shezzer_1972]

Use Data>Validation, and create a List with those values.

 

[Debra Dalgleish]

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

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 here:

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

 

[Bob Phillips]

I thought you wanted the words.

Don't think you can do what you ask, but you could use conditional
formatting to test the value and set the colour to red, amber or green
dependent upon that value.

 

[shezzer_1972]

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]

You're welcome! Thanks for letting me know that it helped you.