Forum Discussion
Conditional Formatting
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.
atravalgia conditional formatting is done relative to the upper left corner of the range it is applied to. so in your case if you use the range B2:C3 and a formula =$C$3="RB" then all cells B2:C3 will be formatted if cell C3 = "RB" but that will only work for that range since you are fixing cell $C$3 absolutely. Now I believe you have spaces above and below and cells to the right and left that in no case should have "RB" or other initials you will probably be looking for so i think this should work to color all "boxes" with the bottom right corner being "RB":
range: B2:Z50
formula: = OR(B2="RB", C2="RB", B3="RB", C3="RB")
and format = red
then repeat for each other color/position
