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 l...
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
$B2