Forum Discussion
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
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.
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.
Better if you submit your file directly here attaching to the post, it'll be easier to illustrate how it work.
