I have a column of dates in order in col A. Sometimes a date is repeated in an adjacent row. I would like to highlight these cells which are repeated and the corresponding next cell to right, B1, B2, B3, etc.
I know how to get the repeated cells in Col A highlighted using "Duplicate Values" in Conditional format, but how do I include the corresponding cells in col B?
EX:
A1 1/1/17
A2 1/2/17
A3 1/3/17-highlighted
A4 1/3/17-highlighted
A5 1/4/17
A6 1/5/17
I want B3 & B4 included in the conditional format so B3 & B4 are also highlighted.
Thank you.
Bookmarks