Forum Discussion
How to highlight cells in the same color as adjacent cells
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
