Search for duplicate data for a specific date

[cstepp]

Sorry if title is a bit misleading. I am trying to find a way to search for duplicate data in columns 1 and 2 to see if they are on the same date that is in column 3. To clarify a bit more, I am creating a sports schedule. In columns 1 and 2 are the home and away teams. In column 3 is the date of the game. I am trying to find a way to ensure that the same team isn't listed twice in either the home or away teams on any given date. In the example below Team A and team B have 2 games on the same date and would need to be identified somehow. Any help to get me started in the right direction would be appreciated.
Thanks in advance.

[TABLE="width: 301"]
<tbody>[TR]
[TD]Home[/TD]
[TD]Visitor[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]Team A[/TD]
[TD]Team B[/TD]
[TD]1/1/2019[/TD]
[/TR]
[TR]
[TD]Team C[/TD]
[TD]Team D[/TD]
[TD]1/1/2019[/TD]
[/TR]
[TR]
[TD]Team A[/TD]
[TD]Team B[/TD]
[TD]1/2/2019[/TD]
[/TR]
[TR]
[TD]Team C[/TD]
[TD]Team A[/TD]
[TD]1/2/2019[/TD]
[/TR]
[TR]
[TD]Team A[/TD]
[TD]Team C[/TD]
[TD]1/3/2019[/TD]
[/TR]
[TR]
[TD]Team B[/TD]
[TD]Team D[/TD]
[TD]1/3/2019[/TD]
[/TR]
[TR]
[TD]Team B[/TD]
[TD]Team E[/TD]
[TD]1/3/2019[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about Conditional format.
Select A2:B last row > Conditional format > New Rule > Use a formula >
=SUMPRODUCT((($A$2:$A$8=A2)+($B$2:$B$8=A2))*($C$2:$C$8=$C2))>1

Select the format > OK

 

[cstepp]

Thanks Fluff. That's exactly what I was looking for.

 

[Fluff]

You're welcome & thanks for the feedback