My application is fantasy football.
I rank football players (1-100), and am able to use conditional formatting on the ranking numbers to achieve a green-white-red spectrum from best to worst. How do I apply the same color for each ranking to the cell containing the name of the player, that is right next to the rank cell (see image)?
I would like to be able to show the rosters of all of the managers in my league. and have each of the players names be shaded based on their ranking, in order to visually appreciate which teams are weaker/stronger at various positions.
I am NOT proficient in VBA, and have mainly only used 'record macros' to do anything more complex than the ribbon tool abilities.
Thanks!
I rank football players (1-100), and am able to use conditional formatting on the ranking numbers to achieve a green-white-red spectrum from best to worst. How do I apply the same color for each ranking to the cell containing the name of the player, that is right next to the rank cell (see image)?
I would like to be able to show the rosters of all of the managers in my league. and have each of the players names be shaded based on their ranking, in order to visually appreciate which teams are weaker/stronger at various positions.
I am NOT proficient in VBA, and have mainly only used 'record macros' to do anything more complex than the ribbon tool abilities.
Thanks!