if the colour has been set by hand someone will post a link for you,if the
colour has been set by conditional format you can set a new column to the
same formula or condtion and sort by that then C then A

--
paul

remove nospam for email addy!



"Bud" wrote:

I have a spreadsheet 8 columns wide and 400+ rows long. Someone has
highlighted (set Pattern color) some of the rows (always a whole row
.... not just some cell in the row) in yellow. I want to sort the
spreadsheet so that all the yellow rows appear at the top of the list
sorted on column C (primary) and A (secondary). How would this be
done?