Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Nov 17, 2025

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 highlighted in Yellow, 331.13 is repeated in ROWS(6,7) so highlighted in Yellow and so on.

if any Conditional formatting or anyother logic, by which we can highlight these data , would be helpful.

Worksheet attached.

Br,

Anupam

 

BI & Data Analysis
excel
Formulas and Functions
power bi

2 Replies

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Nov 17, 2025

    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

Resources