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.