Forum Discussion
Highlighting duplicate cells adjacent to one another across multiple rows
Hi Folks, I’m trying to highlight cells that share the same value and that are adjacent to one another, but copy this formula down to over 900 rows. I have tried selecting all the cells and t...
Shippady Use =$A1=$B1 in stead. Then it shall work as desired. Note that empty cells are equal to zero. So A11: B12 will also be marked. If you don't want that, add another rule (should be the first one like =OR(ISBLANK($A1),ISBLANK($B1)) and check the box "Stop If True"