Sort Rows By Highlight Color in Excel

[service_call]

I have a large Excel 2003 file that has some yellow-highlighted rows. I would love to be able to sort this file by row color. Anyone know and easy answer to my dilemma??


Thanks in advance

[Sunny]

I believe in Excel 2007 there are more options for sorting by color. But as far as I know not in previous versions of Excel.

http://www.cpearson.com/excel/SortByColor.aspx
http://grok.lsu.edu/Article.aspx?articleId=511

[MMFELL]

How are the rows formatted, conditional formatting?
Otherwise its macro time see http://www.ozgrid.com/VBA/Sort.htm and http://www.cpearson.com/excel/SortByColor.aspx

[service_call]

Thanks everyone for your help. I am on it!

[Sunny]

You're welcome.