Filling colour in drop down options

[Mary H]

Hi, just wondering if it is possible to fill colour in drop down options i.e.
you have 3 options and each one is a different colour as well as having data
inside. I haven't been able to get the colours to transfer from the range of
cells to the drop down menu.

 

[Tom Hutchins]

It's possible with VBA. Andy Pope has a downloadable example & instructions
at this link:

http://www.andypope.info/vba/colourdropdown.htm

Hope this helps,

Hutch