Sort by highllighted color
 

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,

Sort by highllighted color
 

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

"Pam C" 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,

Sort by highllighted color
 

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"
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,