I am using Data validation to put drop down lists in my
spreadsheet for about 30 different options. I want to
colour code each option for easy visual management. Is
there a way of creating a drop down list that not only
puts the text in but also the formatting.

The other way to do it is to use conditional formatting,
but i can only have 3 conditions. Can i use any VB code to
put a colour in a box dependent on what the text is, i.e.
if cell contents = two make cell background blue etc.

Any help is greatly appreciated as ever.

Danny.