An idea could be this.

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