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 35 36 37 38 39
| Private Sub Worksheet_Change(ByVal target As Range)
Dim Soustraction As Double
Dim cell As Range
Dim ligne As Integer
Dim col As Integer
ligne = Target.Row
col = Target.Column
For Each cell In Range("H" & ligne & ":AR" & ligne)
Soustraction = Target.Offset(0, 0).value - Target.Offset(0, 1).value
'Mise en forme Conditionnelle Heure de Diner
If Soustraction = "1" Then
'Heure de Diner
If cell.Offset((-ligne + 3), 0).Value < Target.Offset(0, -3).Value + "0,12501" And cell.Offset((-ligne + 3), 0).Value > Target.Offset(0, -3).Value + "0,12499" And Target.Offset(0, 0).Value < 15 And Target.Offset(0, 0).Value > 0 Then
cell.Interior.Color = 255
cell.FormulaR1C1 = ""
cell.Offset(0, 1).Interior.Color = 255
cell.Offset(0, 1).FormulaR1C1 = ""
End If
Else
'Heure de Diner
If cell.Offset((-ligne + 3), 0).Value < Target.Offset(0, -3).Value + "0,12501" And cell.Offset((-ligne + 3), 0).Value > Target.Offset(0, -3).Value + "0,12499" And Target.Offset(0, 0).Value < 15 And Target.Offset(0, 0).Value > 0 Then
cell.Interior.Color = 255
cell.FormulaR1C1 = ""
End If
End If
Next Cell |
Partager