Sub Supp()
Dim Last As Long
Last = [C65000].End(xlUp).Row
For i = Last To 2 Step -1
If Cells(i, 1).Value = "" And Cells(i, 2).Value = "" Then
Rows(i).EntireRow.Interior.ColorIndex = 6 ' pour test
Rows(i).EntireRow.Delete Shift:=xlUp
End If
Next
Gris
End Sub
Sub Gris()
[A1].Select
Selection.CurrentRegion.Select
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=MOD(LIGNE();2)>0"
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorDark1
.TintAndShade = -0.249946592608417
End With
End Sub