Forum Discussion
atravalgia
Sep 05, 2020Copper Contributor
Conditional Formatting
Hello, I have been tasked with creating a draft board for our fantasy football league and am running into a conditional formatting issue.
Here is the sheet: https://docs.google.com/spreadsheets/d/1Jw6zb3spk_Tq-javfIU63OlwQl1wVkxzSXAP1dMUGXY/edit
What I am looking to do is when a player is drafted, have all the associated cells become color coded by position.
So for example, in round one team one selected a “RB”. How do I get cells B2, C2 and C3 to all fill with the color associated to “RB”
I know how to set the conditional format so that the cell that contains “RB” will format to fill whichever color I would like, but don’t know how to get cells B2 and C3 to do the same.
Thank you!
Here is the sheet: https://docs.google.com/spreadsheets/d/1Jw6zb3spk_Tq-javfIU63OlwQl1wVkxzSXAP1dMUGXY/edit
What I am looking to do is when a player is drafted, have all the associated cells become color coded by position.
So for example, in round one team one selected a “RB”. How do I get cells B2, C2 and C3 to all fill with the color associated to “RB”
I know how to set the conditional format so that the cell that contains “RB” will format to fill whichever color I would like, but don’t know how to get cells B2 and C3 to do the same.
Thank you!
10 Replies
- SergeiBaklanDiamond Contributor
To this range
which starts from B2, you may apply the rule
with formula
=(B2="RB")+(B1="RB")+(A2="RB")+(A1="RB")
which triggers formatting if current cell, or one cell up or left, or one cell left and up meet condition.
- atravalgiaCopper Contributor
Thank you for the reply, I tried that and it did not seem to work. I also think I did not explain myself too well the first time. I have update the above sheet. If you look at the first box, I have cell C3 conditionally formatted to fill red because cell C3 reads "RB." With Cells B2 & B3 being associated to cell C3 and "RB" I would like for those two sells to also fill in red.
- SergeiBaklanDiamond Contributor
Better if you submit your file directly here attaching to the post, it'll be easier to illustrate how it work.