Sub tester() Range("D5:H15").Interior.Color = 16777164 For r = 5 To 15 For j = 4 To 8 For c = j + 1 To 8 n1 = Cells(r, j) n2 = Cells(r, c) For r1 = r + 1 To 15 If Cells(r1, j) = n1 And Cells(r1, c) = n2 _ Or Cells(r1, j) = n2 And Cells(r1, c) = n1 Then Cells(r, j).Interior.ColorIndex = 3 Cells(r, c).Interior.ColorIndex = 3 Cells(r1, j).Interior.ColorIndex = 3 Cells(r1, c).Interior.ColorIndex = 3 End If Next r1 Next c Next j Next r End Sub
L2018, 24/01/2024 18:13:ciao Domenico perchè a me viene così ?