Sub MAJ()
Dim t, d As Object, tablo, i&, x$
t = Timer
Set d = CreateObject("Scripting.Dictionary")
Application.ScreenUpdating = False
tablo = Range("B1", Range("C" & Rows.Count).End(xlUp))
'---liste des références en colonne B---
For i = 11 To UBound(tablo)
x = tablo(i, 1)
If x <> "" Then d(tablo(i, 2)) = x
Next
'---coloration du tableau---
Rows("11:" & Rows.Count).Interior.ColorIndex = xlNone 'RAZ
For i = 11 To UBound(tablo)
x = d(tablo(i, 2))
If x <> "" Then Intersect(Range(x), Rows(i)).Interior.Color = RGB(217, 225, 242)
Next
MsgBox "Mise à jour en " & Format(Timer - t, "0.00 \sec")
End Sub