Sub test()
Dim A, i, j, k, n, x, y
With Range("a1:o" & Range("o65536").End(xlUp).Row)
.Interior.ColorIndex = xlNone
A = .Value
End With
n = UBound(A, 2)
For i = 2 To UBound(A)
x = False: y = True
For j = 5 To 3 Step -1
If A(i, j) <> "" Then
For k = 10 To n
If A(i, j) = A(i, k) Then x = True: Exit For
Next
y = y And x
End If
Next
If y And k < n + 1 Then Cells(i, k).Interior.ColorIndex = 3
Next
End Sub