Bonjour,
En reprenant la macro de gmb et en ajoutant la fonction LCase
Remplace la macro par celle-ci
Option Explicit
Dim tabloA, tabloC, tabloD()
Dim i&, ln&
Sub Couleur()
tabloA = Range("A2:B" & Range("A" & 65536).End(xlUp).Row)
tabloC = Range("C2:C" & Range("C" & 65536).End(xlUp).Row)
ReDim tabloD(UBound(tabloC, 1), 1)
For i = 1 To UBound(tabloC, 1)
For ln = 1 To UBound(tabloA, 1)
If LCase(tabloC(i, 1)) Like "*" & LCase(tabloA(ln, 1)) & "*" Then
tabloD(i - 1, 0) = tabloA(ln, 2)
End If
Next ln
Next i
Range("D2").Resize(UBound(tabloD, 1)) = tabloD
Erase tabloD
End Sub