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
[TABLE="width: 198"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Invoice No[/TD]
[/TR]
[TR]
[TD]DODI18090410[/TD]
[/TR]
[TR]
[TD]DODI18090410[/TD]
[/TR]
[TR]
[TD]DODI18100200&DODI18100393[/TD]
[/TR]
[TR]
[TD]DODI18100201&DODI18100393[/TD]
[/TR]
[TR]
[TD]DODI18100190&DODI18100381[/TD]
[/TR]
[TR]
[TD]DODI18100191&DODI18100382[/TD]
[/TR]
[TR]
[TD]DODI18100194&DODI18100389[/TD]
[/TR]
[TR]
[TD]DODI18100195&DODI18100389[/TD]
[/TR]
[TR]
[TD]DODI18100141[/TD]
[/TR]
[TR]
[TD]DODI18100142[/TD]
[/TR]
[TR]
[TD]DODI18100192&DODI18100383[/TD]
[/TR]
[TR]
[TD]DODI18100193&DODI18100384[/TD]
[/TR]
[TR]
[TD]DODI18100204&DODI18100395[/TD]
[/TR]
[TR]
[TD]DODI18100205&DODI18100396[/TD]
[/TR]
</tbody>[/TABLE]

Regards

Hardeep Kanwar