Sub Couleur()
Set Plage = Range("D15:j200")
Plage.FormatConditions.Delete
Texte = "CA": Fond = xlThemeColorAccent5: MFC Plage, Texte, Fond
Texte = "RTT": Fond = xlThemeColorAccent6: MFC Plage, Texte, Fond
Texte = "CR": Fond = xlThemeColorAccent3: MFC Plage, Texte, Fond
End Sub
Sub MFC(Plage, Texte, Fond)
With Plage
.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:=Texte
.FormatConditions(.FormatConditions.Count).SetFirstPriority
.FormatConditions(1).Interior.ThemeColor = Fond
End With
End Sub