Sort by formatting

G

George Wilson

I have a massive spreadsheet I have used a finddups macro
on and have changed the formatting of cells with duplicate
data. I would like to be able to sort or filter the data
by conditional formatting so all the suspect duplicates
can easily be copied to another spreadsheet. Hunt and peck
is not practical with over 50,000 rows. Is there any way
to sort/filter this data? I am currently using Excel XP
and Windows XP.
TIA
George
 
Top