Filter Activated Conditional Formats?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Excel2003 ... 10,000 records using Cols A thru I ... Cols A thru H contain
conditional Formula Statements that identify various errors (Format Cell
Pattern).

Above said ... is there a way to Filter just those records that are being
identified by the Conditional Format as containing errors?

Thanks ... Kha
 
One way is to use a helper col with the same CF formula detecting errors,
then apply autofilter on this col.

Supposing source data is running in row2 down with errors conditionally
formatted based on col A. You could place in say, J2: =ISERROR(A2) and copy
J2 down to the last row of source data. Then just apply autofilter on col J,
filter for TRUE in J1. That should return the filtered results that you're
after.
 
Back
Top