Sort by highllighted color

[Guest]

I have a spreadsheet where I have highlighted certain rows of info with
yellow. Is there a way to sort my spreadsheet where all the highlighted rows
will be at the top. (If this post already appears, I apoloize, my pc shut
down as I was trying to post the same question).

Thanks,

 

[Paul B]

Pam, see if this will help.

http://www.cpearson.com/excel/SortByColor.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Jim Cone]

or see...
http://www.officeletter.com/blink/specialsort.html
for a review of a commercial sorting application by yours truly.
Jim Cone
San Francisco, USA


"Pam C" <[email protected]>
wrote in message
I have a spreadsheet where I have highlighted certain rows of info with
yellow. Is there a way to sort my spreadsheet where all the highlighted rows
will be at the top. (If this post already appears, I apoloize, my pc shut
down as I was trying to post the same question).
Thanks,