Sub couleur_satisfaction_c()
Dim K_olor, i%
K_olor = Array(Array("Satisfait", RGB(112, 173, 71)), Array("Mitigé", RGB(255, 192, 0)), Array("risque", RGB(255, 0, 0)))
For i = LBound(K_olor) To UBound(K_olor)
With Sheets("Christelle").Range("U2:U501")
.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:=K_olor(i)(0)
.FormatConditions(i + 1).Interior.Color = K_olor(i)(1)
End With
Next
End Sub