Sub TEST()
Application.ScreenUpdating = False
With Sheets("Feuil2")
.Range("D2:D30").Interior.Color = RGB(255, 255, 255)
End With
For Each xCell In Range("C2:C30")
xEquiv = Application.Match(xCell.Value, Sheets("Feuil2").Range("D2:D30"), 0)
If IsError(xEquiv) = False Then
If xCell.Interior.Color = RGB(0, 176, 80) Then
With Sheets("Feuil2")
.Range("D" & xEquiv + 1).Interior.Color = RGB(0, 176, 80)
End With
End If
End If
Next xCell
Application.ScreenUpdating = True
MsgBox "Mise à jour terminée", vbInformation, "MAJ"
End Sub