excel 2007 multiple sort criteria

[Guest]

I don't know if this is even possible, but within excel (2007) Can i set up
different sort criteria based on a value? Say for instance, I have one column
that I have colored blue. (which I have sorted to the bottom). So I want to
sort the stuff that on the top (which is not blue) in a different sequence
from the stuff that is on the bottom. Ie. The stuff where the required date
is not blue should be sorted by Customer then PO# then Div. where the blue
should be sorted by Start Date Then by PO#, then by Div. Can I do this
without cut/paste to a different worksheet?
Thank you,

 

[Jim Rech]

The Excel 2007 "Sort On" drop down lets you pick cell color or font color to
sort on. You'd have to see if it does what you need.

--
Jim
|I don't know if this is even possible, but within excel (2007) Can i set up
| different sort criteria based on a value? Say for instance, I have one
column
| that I have colored blue. (which I have sorted to the bottom). So I want
to
| sort the stuff that on the top (which is not blue) in a different sequence
| from the stuff that is on the bottom. Ie. The stuff where the required
date
| is not blue should be sorted by Customer then PO# then Div. where the
blue
| should be sorted by Start Date Then by PO#, then by Div. Can I do this
| without cut/paste to a different worksheet?
| Thank you,