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
SetupI 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