View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Linda Hudock
 
Posts: n/a
Default 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?