Sub RepereCouleurs()
Dim t, c As Range, coul&, Z As Range, P As Range
t = Timer
For Each c In [E4:IY53] 'plage à adapter
coul = c.DisplayFormat.Interior.ColorIndex
If coul = xlNone Then
Set Z = Union(IIf(Z Is Nothing, c, Z), c)
ElseIf coul <> 48 And coul <> 49 Then 'ni gris ni bleu foncé
Set P = Union(IIf(P Is Nothing, c, P), c)
End If
Next
Application.ScreenUpdating = False
If Not Z Is Nothing Then Z.Replace 1, "", xlWhole 'RAZ
If Not P Is Nothing Then P.NumberFormat = "0": P = 1 'repère
MsgBox "Couleurs repérées en " & Format(Timer - t, "0.00 \s")
End Sub