Salut j'ai un code pour mettre de la couleur sur une cellule mais je
n'arrive pas a mettre la condition sur la couleur de police...
merci de votre aide...
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("$AZ$6:$AZ$53")) Is Nothing
Then 'Plage =E0 modifie
Select Case Target.Value
Case Is =3D ""
Target.Interior.ColorIndex =3D 2
Case Is =3D "Lundi"
Target.Interior.ColorIndex =3D 36
Case Is =3D "Mardi"
Target.Interior.ColorIndex =3D 35
Case Is =3D "Mercredi"
Target.Interior.ColorIndex =3D 37
Case Is =3D "Jeudi"
Target.Interior.ColorIndex =3D 38
Case Is =3D "Vendredi"
Target.Interior.ColorIndex =3D 48