Ron,

EUREKA !! (excuse the shouting)

Stupid is as stupid does. Made everything absolute Col / relative Row (was
doing this incorectly). Highlights two colors and Sorts perfectly. Could
have never done this without your help. As an aside I am 76 years old and
trying to teach myself Excel. All the things I do is for other people,
groups, so sometimes I get myself in over my head. Again, Thanks so much!

Would love to see the "worksheet" you refered to.

email:

Bob

"Ron Rosenfeld" wrote:

On Mon, 27 Aug 2007 21:02:04 -0700, robert morris
wrote:

Ron,

One last question on this Cond formating. As I said, your solution works
perfectly as to Col/Row I12. I have sorted the row from every angle.
Problem is in trying to copy down to the 150 rows I need. I have tried
changing absolute reference to relative which excel will not allow as it just
returns all to absolute. You said "after I copy the mixed reference
conditional formating, make the whole definition of RNG relative" How do I
make this a "mixed reference" as well as make the whole definition of RNG
relative. I have also searched "help" and found nothing.

Sorry for the stupidity,

Bob

The easiest way is to select the Refers To: block in the Insert/Name/Define
dialog, and then use F4 until you get the fixed column; relative row format
(e.g. $I12)

I've not seen the problem of "returning all to absolute".

I have a worksheet I can send you if you have an email address I can use.


--ron