Re,
J'ai opté pour la simplicité et nommé la cellule H19 (_Note).
Voir ton fichier en retour.
Cdlt.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cht As Chart
Dim s As Series, vals
Dim i As Double, xRGB As Long
If Target.Address = "$F$5" Then
Set cht = Me.ChartObjects("Graphique 1").Chart
Set s = cht.SeriesCollection(1)
vals = s.Values
For i = LBound(vals) To UBound(vals)
Select Case vals(i)
Case Is < 1.5: xRGB = RGB(255, 0, 0)
Case Is < 2.5: xRGB = RGB(255, 192, 0)
Case Is < 3.5: xRGB = RGB(102, 255, 153)
Case Else: xRGB = RGB(0, 255, 0)
End Select
s.Points(i).Interior.Color = xRGB
Next i
Set cht = Me.ChartObjects("Graphique 2").Chart
Set s = cht.SeriesCollection(1)
Select Case [_Note]
Case Is <= 5: xRGB = RGB(255, 0, 0)
Case Is <= 10: xRGB = RGB(255, 192, 0)
Case Is <= 15: xRGB = RGB(102, 255, 153)
Case Else: xRGB = RGB(0, 255, 0)
End Select
s.Points(1).Interior.Color = xRGB
End If
End Sub