Hi

I used validation function to create a drop down list. b3 to b42 uses the
same formaula that shows a list from b47:b172. I added 7 or 8 background
colors within the b47:b172 cells. is there anyway to get the background
color to show when i select them in the b3 to b42 drop downs?