Highlight rows where certain duplicate criteria is not met

[joeyb]

I need some help locating lines in a daily sales report where two sales associates have contributed to the same sale. This is apparent if two different sales associates appear against one transaction, with the same product ID.

See example below, Unique Transaction ID 2 is exhibiting the scenario I am trying to identify and highlight somehow:

[TABLE="width: 897"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Unique Transaction ID[/TD]
[TD]Sales Associate ID[/TD]
[TD]Product ID[/TD]
[/TR]
[TR]
[TD]18/10/17[/TD]
[TD]1[/TD]
[TD]111[/TD]
[TD]ItemA[/TD]
[/TR]
[TR]
[TD]18/10/17[/TD]
[TD]1[/TD]
[TD]111[/TD]
[TD]ItemB[/TD]
[/TR]
[TR]
[TD]18/10/17[/TD]
[TD]2[/TD]
[TD]111[/TD]
[TD]ItemC[/TD]
[/TR]
[TR]
[TD]18/10/17[/TD]
[TD]2[/TD]
[TD]222[/TD]
[TD]ItemC[/TD]
[/TR]
[TR]
[TD]18/10/17[/TD]
[TD]3[/TD]
[TD]111[/TD]
[TD]ItemC[/TD]
[/TR]
[TR]
[TD]18/10/17[/TD]
[TD]4[/TD]
[TD]222[/TD]
[TD]ItemA[/TD]
[/TR]
</tbody>[/TABLE]


Is there a formula I can use to highlight all transactions that meet this criteria?


Thanks in advance![/TD]
[/TR]
</tbody>[/TABLE]

 

[joeyb]

I'm thinking perhaps I didn't select the best title for the post.

Having slept on it I think what I am trying to do is highlight cells where an expected duplicate is not present. For every duplicate transaction ID row there should be a corresponding duplicate Sales Associate ID. If that is not true, highlight the cell / row.