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

@tdunkle 

 

Afraid that's only with VBA programming. Formulas works with cells values, not with their properties as color.