Bonsoir,
Je verrai plutôt <=2 et <=4 ---> 0
Cdlt
Option Explicit
Public Sub Consolidation()
Dim Ws As Worksheet
Dim Derligne As Long, i As Long
Application.ScreenUpdating = False
Set Ws = Worksheets("Feuil1")
With Ws
.Columns(1).Insert
Derligne = .Range("B" & Rows.Count).End(xlUp).Row
For i = 2 To Derligne
If .Cells(i, 9) < 2 And .Cells(i, 10) < 4 Then .Cells(i, 1) = 0
If .Cells(i, 9) >= 2 Or .Cells(i, 10) >= 4 Then .Cells(i, 1) = 1
Next
End With
Set Ws = Nothing
End Sub