1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| Private Sub Worksheet_Change(ByVal Target As Range)
'Updateby Extendoffice 20160704
If Intersect(Target, Range("D2:F2")) Is Nothing Then Exit Sub
For Each Cellule In Range("E14:E16")
If IsNumeric(Cellule.Value) Then
Select Case Cellule.Row
Case 14: Set sh = ActiveSheet.Shapes("ARA")
Case 15: Set sh = ActiveSheet.Shapes("EPA")
Case 16: Set sh = ActiveSheet.Shapes("DHA")
End Select
If Cellule.Value >= 50000 Then
sh.Fill.ForeColor.RGB = RGB(255, 192, 0)
ElseIf Cellule.Value < 50000 And Cellule.Value >= 5000 Then
sh.Fill.ForeColor.RGB = RGB(251, 221, 41)
ElseIf Cellule.Value < 5000 And Cellule.Value >= 500 Then
sh.Fill.ForeColor.RGB = RGB(255, 255, 0)
ElseIf Cellule.Value < 500 And Cellule.Value >= 50 Then
sh.Fill.ForeColor.RGB = RGB(255, 255, 153)
ElseIf Cellule.Value < 50 And Cellule.Value >= 5 Then
sh.Fill.ForeColor.RGB = RGB(255, 255, 204)
ElseIf Cellule.Value < 5 And Cellule.Value >= 0.8 Then
sh.Fill.ForeColor.RGB = RGB(255, 255, 230)
Else
sh.Fill.ForeColor.RGB = RGB(230, 230, 230)
End If
End If
Next Cellule
End Sub |
Partager