When I go through the for loop, it starts off working, but as I go down the column the cells are not deleted nor highlighted in red.
For i = 2 To lngRow
If Cells(i, 27).Value = "Completed" Or IsEmpty(Cells(i, 27).Value) = True Then
'Do nothing
Else
'Go into the exception items'
If Cells(i, 28).Value = "Contact Information Not Found" Then
'Check Code: If identifiable (4 digits long + starts with a F), highlight
If Len(Cells(i, 4).Value) = 4 And Left(Cells(i, 4), 1) = "F" Then
Cells(i, 28).Interior.Color = RGB(255, 0, 0)
Else
'Otherwise, delete
Rows(i).EntireRow.Delete
End If
ElseIf Cells(i, 28).Value = "Invalid Account Number." Then
End If
End If
Next i