Sub TestCouleur()
Dim c As Variant
Dim d As Object
Set d = CreateObject("Scripting.Dictionary")
For Each c In Range("b:b")
If c.Interior.Color = 5287936 Then
d(c.Row) = 2
ElseIf c.Interior.Color = 5287935 Then
d(c.Row) = 3
End If
Next c
For Each c In d.keys
Cells(c, 1).Value = d(c)
Next c
End Sub