How do I delete all rows that contain no red highlighted data?
I have a LARGE spreadsheet in which have highlighted erroneous data in red.
I would like to know how to quickly and easily delete any row in the sheet
that does not have red highlighted data in it so that I can count the number
of records that have erroneous data using subtotals. Or, is there is a
better way to do this than deleting the rows w/o red highlighted data?
|