Sub ColorerTypes()
Dim T(), L&, TSpl() As String, D As New Scripting.Dictionary, PlgLst As Range, Code
T = Feuil1.ListObjects("Tab_Catégorie").DataBodyRange.Value
For L = 1 To UBound(T)
TSpl = Split(T(L, 2), ",")
D.Add T(L, 1), RGB(TSpl(0), TSpl(1), TSpl(2))
Next L
Set PlgLst = Feuil1.ListObjects("Tab_Liste").DataBodyRange
For L = 1 To PlgLst.Rows.Count
Code = PlgLst(L, 2).Value
If D.Exists(Code) Then PlgLst(L, 1).Interior.Color = D(Code)
Next L
End Sub