Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$10" Then
With Me.Shapes("Rectangle 1").Fill
.Visible = msoTrue
.ForeColor.RGB = IIf([G10] = "OK", RGB(0, 176, 80), RGB(255, 0, 0))
.Transparency = 0
.Solid
End With
End If
End Sub