Sub colorier()
Set f1 = Sheets("texte")
Set f2 = Sheets("liste")
derLigne1 = f1.Cells(Rows.Count, 1).End(xlUp).Row
derLigne2 = f2.Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To derLigne1
ligneAnalysée = Replace(Replace(Replace(UCase(f1.Cells(i, 1)), ".", " "), ",", " "), "'", " ")
For j = 2 To derLigne2
mot = UCase(f2.Cells(j, 1))
mots = Split(ligneAnalysée, " ")
p = 1
For k = LBound(mots) To UBound(mots)
If mot = mots(k) Then f1.Cells(i, 1).Characters(Start:=p, Length:=Len(mot)).Font.Color = vbRed
p = p + Len(mots(k)) + 1
Next k
Next j
Next i
End Sub