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/1...
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.
Thank you. I updated the rule for RB, please check if that what you'd like to have.
If so other rules could be updated with the same logic.