I have a work sheet called Current
and within it a Column SportsTeam
. The values for SportsTeam
are populated as a dropdown list. The values for the dropdown list are in worksheet called Setup
. In Setup
I have two columns:
Name of team | Team Colour
Warriors | Cell bkrd color is team colour
Cougars | Cell bkrd color is team colour
etc.
I populate the dropdown in Current
with the values of the Column Name Of Team
.
I want that, when a user selects a Team name from the dropdown in worksheet Current
, that cell background colour changes to the corresponding Team Colour
.