ExcelBanter - View Single Post

robert morris

Ron,

Yes, please send the worksheet.

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