Sub DuVertAuJaune()
Dim xsp As Shape, xt
On Error Resume Next
With ActiveSheet
On Error Resume Next
For Each xsp In .Shapes
xt = "": xt = xsp.TextFrame2.TextRange.Text
If xt <> "" And CInt(xt) = .Range("d1") Then xsp.Fill.ForeColor.RGB = RGB(255, 255, 0)
Next xsp
On Error GoTo 0
End With
End Sub
Sub ReInit()
Dim xsp As Shape, xt
On Error Resume Next
With ActiveSheet
On Error Resume Next
For Each xsp In .Shapes
xt = "": xt = xsp.TextFrame2.TextRange.Text
If IsNumeric(xt) Then xsp.Fill.ForeColor.RGB = RGB(127, 255, 0)
Next xsp
On Error GoTo 0
End With
End Sub