Sorting rows by colors
 

I have a spreadsheet with about 13000 rows. Some of these rows are
highlighted. Is there a way, or a macro that will let me sort the
spreadsheet where the highlighted rows are at the top of the spreadsheet? I
am using excel 2002.

Thanks

Sorting rows by colors
 

You need to use a macro. See he
http://www.cpearson.com/Excel/SortByColor.htm

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"James O" wrote:

I have a spreadsheet with about 13000 rows. Some of these rows are
highlighted. Is there a way, or a macro that will let me sort the
spreadsheet where the highlighted rows are at the top of the spreadsheet? I
am using excel 2002.

Thanks