I have a drop down list made with data validation. The list is from j100 to j163.
I would like to have the drop down list change the color of the selected item from the list based on which cell the selection is in.
For example if i choose a selction from my drop down list that is from cells J100 to J111 i want it to show up red. If i choose a selection that is from J112 to J125 i want it to show up blue and so on.
HELP PLEASE,

If anyone want a Sample to see exactly what i am trying to achieve please let me know.