Private Sub Worksheet_Activate()
Dim s As Shape, c As Range, v#
Application.ScreenUpdating = False
'---RAZ---
For Each s In Shapes
s.Fill.ForeColor.RGB = 16777215
Next
'---Couleur---
On Error Resume Next
For Each c In Feuil1.PivotTables(1).TableRange1.Columns(1).Cells
Set s = Nothing
Set s = Shapes("FR-" & IIf(IsNumeric(c), Format(c, "00"), c))
v = Val(Replace(CStr(c(1, 5)), ",", "."))
If v > 0 Then s.Fill.ForeColor.RGB = IIf(v < 0.88, 255, IIf(v >= 0.88 And v < 0.94, 49407, 5296274))
Next
End Sub