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 30 31 32 33 34
| Sub CouleurPC()
Dim numDep As Integer
Dim PC As Double
Worksheets("Mois").Select
For numDep = 1 To 16
PC = WorksheetFunction.VLookup(numDep, Range("C6:H21"), 6, False)
If PC >= Cells(38, 12).Value Then
valcouleur = Cells(38, 12).Interior.Color
ElseIf PC > Cells(39, 12).Value Then
valcouleur = Cells(39, 12).Interior.Color
ElseIf PC > Cells(40, 12).Value Then
valcouleur = Cells(40, 12).Interior.Color
ElseIf PC > Cells(41, 12).Value Then
valcouleur = Cells(41, 12).Interior.Color
ElseIf PC > Cells(42, 12).Value Then
valcouleur = Cells(42, 12).Interior.Color
Else
valcouleur = Cells(43, 12).Interior.Color
End If
Application.Worksheets("Fiche sign.").Shapes("Ré" & Format(numDep, "00")).Select
Selection.ShapeRange.Fill.ForeColor.RGB = valcouleur
Next numDep
Range("F25").Select
End Sub |
Partager