Sub couleur()
With Feuil1.Shapes("LeNom") ' **A adapter**
.TextFrame.Characters.Font.Bold = True
If .TextFrame.Characters.Text = "Supprimer cette personne de l'annuaire" Then '**ou cellule**
.TextFrame.Characters.Font.ColorIndex = 3
Else
.TextFrame.Characters.Font.ColorIndex = 5
End If
End With
End Sub