Drop Down list with colours

  • Thread starter Thread starter Paul
  • Start date Start date
P

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.
 
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.
 
Back
Top