i just check a mock sheet trying selecting coulumns e:iv and going to format
and reseting to general.

Select those empty rows again and go to Format-Conditional Formatting.
Select Delete and check all three condistions.  Click OK.  OK again.
Now try it.

Regards,
Paul

You deleted the columns E through IV. You need to save the book however to
reset the used range. Note that the used range is not always what you would
think it is so you want to be careful using it in code... Here is some code
to find the bottom right most cell without refering to the used range...

Public Function LastCell(Optional ByVal wks As Worksheet) As Range
   Dim lngLastRow As Long
   Dim intLastColumn As Integer
   
   If wks Is Nothing Then Set wks = ActiveSheet
   On Error Resume Next
   lngLastRow = wks.Cells.Find(What:="*", _
                           After:=wks.Range("A1"), _
                           Lookat:=xlPart, _
                           LookIn:=xlFormulas, _
                           SearchOrder:=xlByRows, _
                           SearchDirection:=xlPrevious, _
                           MatchCase:=False).Row
   intLastColumn = wks.Cells.Find(What:="*", _
                           After:=wks.Range("A1"), _
                           Lookat:=xlPart, _
                           LookIn:=xlFormulas, _
                           SearchOrder:=xlByColumns, _
                           SearchDirection:=xlPrevious, _
                           MatchCase:=False).Column
   On Error GoTo 0
   If lngLastRow = 0 Then
       lngLastRow = 1
       intLastColumn = 1
   End If
   Set LastCell = wks.Cells(lngLastRow, intLastColumn)
   
End Function