Thread: Sort by color?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bud Bud is offline
external usenet poster
 
Posts: 1
Default Sort by color?

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?