Sep 05 2020 10:05 AM
Sep 05 2020 10:27 AM
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.
Sep 05 2020 12:32 PM
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.
Sep 05 2020 01:00 PM
@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
Sep 05 2020 01:10 PM
Better if you submit your file directly here attaching to the post, it'll be easier to illustrate how it work.
Sep 05 2020 02:23 PM
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.
Sep 05 2020 02:39 PM
Sep 05 2020 02:52 PM
Good. Steps are
- select and edit your existing rule
- change Rule type on Use a formula... and copy / paste formula from rule I updated
- change in formula RB om proper text. To edit the formula in a bar press F2
- keep format as it is, Ok and in next window Apply
- repeat for other rules
Sep 05 2020 07:29 PM