I've got a list of 37 condition statements which i've combined into a
valdiated drop down list, but I need the cell adjacent to the list to dispaly
one of 37 unique colour a pattern combinations to allow mutiple selections on
the sheet to be easily read to assess commonality. Any sugestions as to how I
do this, I'm pretty new to VB in Excel2003.

Simplest case is an 8Rx2C matrix with column 1 being the output in terms of
shading and patterns and column 2 being the drop down selection.

Thanks for any help
Dave