Sub Macro4()
Dim numero As Integer
For numero = 2 To 937 Step 2
With Cells(numero, 2)
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="=$E$" & numero & "=1"
.FormatConditions(1).Interior.ColorIndex = 3
.FormatConditions.Add Type:=xlExpression, Formula1:="=$F$" & numero & "=1"
.FormatConditions(2).Interior.ColorIndex = 6
End With
Next
End Sub