Sub FaseHeure()
Dim Coul As Integer, Cumul As Integer
With Worksheets('Fase M2P')
For colIndex = 6 To 129
Cumul = 0
For rwIndex = 14 To 27
'Si cellule en vert ou gris
Coul = .Cells(rwIndex, colIndex).Interior.ColorIndex
If Coul = 35 Or Coul = 15 Then
'On fait le cumul de la Durée
Cumul = Cumul + .Cells(rwIndex, 4)
End If
Next rwIndex
'Affichage du cumul
.Cells(3, colIndex).Value = Cumul
Next colIndex
End With
End Sub