Highlight Duplicate using conditional formatting

[hardeep.kanwar]

Hi Expert

Can i highlight the duplicate using CF,I know how to highlight duplicate if value is single,but problem is i have 2 value with delimited with "/"

Few examples for your reference,see highlight with RED

Invoice No

DODI18090410

DODI18090410

DODI18100200&DODI18100393

DODI18100201&DODI18100393

DODI18100190&DODI18100381

DODI18100191&DODI18100382

DODI18100194&DODI18100389

DODI18100195&DODI18100389

DODI18100141

DODI18100142

DODI18100192&DODI18100383

DODI18100193&DODI18100384

DODI18100204&DODI18100395

DODI18100205&DODI18100396

 

[rahulshewale1]

Hii @hardeep.kanwar ,


See if is ok ?


Using Helper Column (Which is hide in sheet)


Regard
Rahul shewale