Sub Bouton1_QuandClic()
Dim c As Range
Dim caractere As Variant
Dim i, j As Byte
caractere = Array('&', '*') '<==== à adapter
For Each c In Range('a1:d5') '<==== à adapter
c.Interior.ColorIndex = -4142
For i = 1 To Len(c)
For j = 0 To UBound(caractere)
If Mid(c, i, 1) = caractere(j) Then
c.Interior.ColorIndex = 6
End If
Next j
Next i
Next c
End Sub