Sub Essai_5()
Dim dL&, i
Application.ScreenUpdating = False
dL = Cells(Rows.Count, 1).End(xlUp).Row
With Range("A1", Range("A" & Rows.Count).End(xlUp))
.SpecialCells(xlBlanks).FormulaR1C1 = "=R[1]C"
.Value = .Value
End With
For i = dL + 1 To 1 Step -1
If Cells(i, 1).Interior.ColorIndex = 6 Then
Cells(i, 1).EntireRow.Delete
End If
Next
End Sub