Color Coded Dropdown Lists

[ManOman]

I was wondering if anyone could tell me if it was possible to color cod
a dropdown list for a cell. The dropdown lists start at B3 an
continue out for the rest of the sheet and down to B46. There are nin
different subjects to choose from in the dropdown list that I nee
color coded so that we can have a quick visual overview just by lookin
at the sheet.
Thanks much in advance :

 

[ManOman]

Ok, I've changed the dropdown list to reference colored cells, but whe
I choose a category from the list, I can't get the color formatting t
follow through to the chosen cell. Is there a way anyone knows of t
do this

 

[ManOman]

*bump* for hoping -someone- will know :

 

[Debra Dalgleish]

You can't format the items in a Data Validation dropdown list. Perhaps
you could use dependent dropdowns, with the first dropdown containing
the subject list, and the second dropdown showing only items from that
subject. There are instructions here:

http://www.contextures.com/xlDataVal02.html

 

[ManOman]

That's great, I'll try that. Thank you for the help