hi
excel does not have this functionality built in. but quite a number of
people have wanted to do just that. so programmers have found ways to do it.
see this site...
http://www.cpearson.com/excel/sortbycolor.htm

Regards
FSt1

"Mo" wrote:

Is there a way to filter by format? For example, a spreadsheet that has
20,000 rows with some rows highlighted yellow and some rows are not
highlighted. How can I isolate the highlighted rows that are not consecutive
while saving time?

I'm currently using Excel 2003