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,

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
"Abbey Normal" wrote in message
...
|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,