Sub Couleur()
Colour = Array(xlNone, 37, 3)
Set D = CreateObject("Scripting.Dictionary")
For Each Cel In Range("A2", [A65536].End(xlUp))
If Cel <> "" Then D.Item(Cel.Value) = D.Item(Cel.Value) & Cel.Address & ":"
Next Cel
For Each Cela In D.keys
tmp = D.Item(Cela)
tmp = Left(tmp, Len(tmp) - 1)
A = Split(tmp, ":")
For i = LBound(A) To UBound(A)
If i < 3 Then Range(A(i)).Resize(, 4).Interior.ColorIndex = Colour(i) Else Range(A(i)).Resize(, 4).Interior.ColorIndex = Colour(2)
Next i
Next Cela
End Sub