Drop Down list with colours

[Paul]

Hi,

Is there any way in Excel to create a drop down list which contains colours?
For example to show RAG status (i.e. Red Amber Green).

At the moment I can only show text in the drop down list.

Would anyone know a way of working around this?

Thanks.

 

[Paul]

Thanks Roger, and Chip, for replying.

I was playing around with it and found that I could conditionally format the
cell depending on the text selected - so if I choose "RED" it goes red. It's
just about enough to work for what I intend to use it for, but I'll
experiment with your suggestion in case I need to develop things a bit more.

Paul.