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...
assuminig the sfn is alway 3 digits then conditional formatting -> custom formula:
=($A2&$B2=$A1&$B1)+($A2&$B2=$A3&$B3)
Applies to range A2:B22
if sfn might be 2 or 4 digits then you might need to add a separator character to 12 & 10 isn't mistaken as 121 & 0. So simply adding something like a period between each pair like: $A2&"."&$B2