How do I sort rows by color?

[Guest]

Hi,

I have a worksheet with around 1000 rows of information, some of them are
yellow and others are white.
Is it there any way I can sort by colors and put the yellow rows on top and
the white ones at the bottom?

 

[Pete_UK]

This link to Chip Pearson's site explains how to do it:

http://www.cpearson.com/excel/SortByColor.htm

Hope this helps.

Pete