Conditional Formatting with two values

[DenialDan]

[TABLE="width: 500"]
<tbody>[TR]
[TD]123456
[/TD]
[TD]Murdock
[/TD]
[/TR]
[TR]
[TD]123555
[/TD]
[TD]Murdock
[/TD]
[/TR]
[TR]
[TD]123456
[/TD]
[TD]Murdock
[/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to get the first and the third rows to get filled in a Color since both the ID and the Name are the same value. The second row should not be filled.
Any ideas?

 

[AlphaFrog]

Use COUNTIFS or SUMPRODUCT

=COUNTIFS($A$1:$A$10,$A1,$B$1:$B$10,$B1)>1

=SUMPRODUCT(($A$1:$A$10=$A1)*($B$1:$B$10=$B1))>1