Forum Discussion
MrsJohnson
Apr 09, 2022Copper Contributor
Is it possible to format the fill color of a cell to equal the fill color of another cell?
I have a spreadsheet with with columns conditionally formatted to fill (highlight) based upon the text of another cell. For example, the formula in C3 is '=$E$2', and if E2 contains "STS" the Condi...
mtarler
Silver Contributor
the answer is most likely yes. You can highlight multiple cells the same way when using CF and using a custom rule. Just make the Applied To range cover each cell you want formatted that way and then create the formula so that the conditional is using ABSOLUTE references ($) accordingly. So if J15 has a rule =(E15="abc") then change the rule to include J16 in the Applied To range and change the formula to =(E$15="abc") so that when excel moves from J15 to J16 the row in E15 wont change because of the $ (of course you could also lock the column and use $E$15)
TemporaryUser314
Sep 07, 2023Copper Contributor
I apologize,
(Highlight [J15(+2 cells to the right)] without having to do it manually?)
The 2 cells to the right would be K15 and L15.
Maybe another way of saying it would be, I want to highlight (or condition) the 2 cells to the right of the pre-conditioned cell, J15.
If the cell in column A were to trigger a different cell, say R15, then it would instead highlight S15 and T15 respectively.
On a timeline it would simply look like the next 15 minutes were blocked out.
(Highlight [J15(+2 cells to the right)] without having to do it manually?)
The 2 cells to the right would be K15 and L15.
Maybe another way of saying it would be, I want to highlight (or condition) the 2 cells to the right of the pre-conditioned cell, J15.
If the cell in column A were to trigger a different cell, say R15, then it would instead highlight S15 and T15 respectively.
On a timeline it would simply look like the next 15 minutes were blocked out.