Forum Discussion
How to highlight duplicated sequential rows
I have a data like below sfn can range from 0~1023, and then again start with 0, slots can range from 0~19 I want to highlight the rows like below:- so, 331.12 is repeated in ROWS(4,5) so highl...
Try the following custom conditional formatting rule.
=OR(AND(A2=A3,B2=B3),AND(A2=A1,B2=B1))