Sub MOT_EN_COULEUR()
Dim Plage As Range, mot$
Set Plage = [D4:D40]
mot = Range("M1")
If mot <> "" Then rouletambourg Plage, mot, vbWhite
End Sub
Sub rouletambourg(Plage As Range, mot As String, Optional couleur As Long = vbRed)
Dim cel As Range, i&
For Each cel In Plage.Cells
Debug.Print cel.Value ' Application.Rept("0", Len() - 1)
If cel <> "" Then
If "R" & Replace(cel.Text, "R", "") = cel.Value Then
cel.Characters(1, 1).Font.Color = IIf(cel.Row Mod 2 = 0, vbWhite, &HE0E0E0)
End If
End If
Next
End Sub