Sub Colorier()
Dim P As Range, c1 As Range, coul&, L%, c2 As Range, i%, j%
Application.ScreenUpdating = False
Set P = [A1].CurrentRegion.Offset(1) 'évite l'en-tête
P.Font.ColorIndex = xlAutomatic 'RAZ
P.Font.Bold = False 'RAZ
For Each c1 In [D2:D4]
coul = c1.Characters(1, 1).Font.Color
L = Len(c1)
For Each c2 In P
i = 1
Do
j = InStr(i, c2, c1)
If j Then
c2.Characters(j, L).Font.Color = coul
c2.Characters(j, L).Font.Bold = True 'gras
i = j + L
End If
Loop While j
Next c2, c1
End Sub