Re,
Voir Feuil2 et sa procédure événemetielle.
Cdlt.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim txt As String, m As Long, n As Long
If Target.CountLarge > 1 Then Exit Sub
If Not Intersect(Target, Me.Cells(4, 8).CurrentRegion) Is Nothing Then
txt = Trim(Target.Text)
m = Len(txt)
n = WorksheetFunction.Find(Chr(10), txt)
Target.Characters(Start:=n + 1, Length:=m).Font.Color = -16776961
End If
End Sub