To find records that have no conditional formatting icon, use an operator of xlFilterNoIcon and do not specify any criteria. : AutoFilter « Excel « VBA / Excel / Access / Word
To find records that have no conditional formatting icon, use an operator of xlFilterNoIcon and do not specify any criteria.
Sub FilterByIcon()
Worksheets("SalesReport").Select
Range("A1").AutoFilter
Range("A1").AutoFilter Field:=6,Criteria1:=ActiveWorkbook.IconSets(xl5ArrowsGray).Item(5),Operator:= xlFilterNoIcon
End Sub