How to highlight cells in the same color as adjacent cells

Copper Contributor

This should be EASY, but darned if I can find it by googling or by searching Excel's help.

 

How do I automatically highlight each of the cells in a column with the same color as the cells to the left or right of them?

That is, if a cell in column B is highlighted green, how do I make the adjacent cell in column C also highlight in green? And if B is pink, make C also pink? And so on.

I don't want the formula for C to do ANYTHING but match the highlighting in B. The formula should not involve the actual values in either column -- it's all about the highlight color and ONLY the highlight color.

1 Reply
In defining the conditional formatting formula, select columns B and C, then in the formula, use Absolute reference for column B and relative for the row number, like this:
$B2