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.