I have the following Conditional Formatting Formula (which works for the one
Row); =D11=MAX($D$11,$F$11,$H$11,$J$11,$L$11,$N$11)

Problem is I cannot copy this row down as needed. Excel always converts the
Relative references to Absolute. I have used F4 to toggle to Relative but
soon as I "Apply" they convert back to Absolute.

What am I missing? Also, I'm using Office 2007.

Bob

It works for me.

Are you sure that's the correct formula you want to use?

I'm thinking you probably want to use this:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Let's assume your data is from row 11 to row 20.

Select the range D11:D20

Goto Home tabStylesConditional FormattingNew RuleUse a formula to....

Enter this formula:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Click the Format button
Select the Fill tab
Select the desired color
OK out

--
Biff
Microsoft Excel MVP


"robert morris" wrote in message
...

I have the following Conditional Formatting Formula (which works for the
one
Row); =D11=MAX($D$11,$F$11,$H$11,$J$11,$L$11,$N$11)

Problem is I cannot copy this row down as needed. Excel always converts
the
Relative references to Absolute. I have used F4 to toggle to Relative but
soon as I "Apply" they convert back to Absolute.

What am I missing? Also, I'm using Office 2007.

Bob

Biff,

Nothing works. Excel always changes the Relative Cells to Absolute. I've
tried everything. The range of D11:D20 changes to $D$11:$D$20 and colors
every row. I also tried Range of D11,F11,H11,J11,L11,N11. Same problem,
all cells color until one cell is selected in a Row. That Row then works
correctly one time through, then the second test run on that Row leaves all
cells colored. I'm lost! Any more ideas?

Bob

"T. Valko" wrote:

It works for me.

Are you sure that's the correct formula you want to use?

I'm thinking you probably want to use this:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Let's assume your data is from row 11 to row 20.

Select the range D11:D20

Goto Home tabStylesConditional FormattingNew RuleUse a formula to....

Enter this formula:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Click the Format button
Select the Fill tab
Select the desired color
OK out

--
Biff
Microsoft Excel MVP


"robert morris" wrote in message
...

I have the following Conditional Formatting Formula (which works for the
one
Row); =D11=MAX($D$11,$F$11,$H$11,$J$11,$L$11,$N$11)

Problem is I cannot copy this row down as needed. Excel always converts
the
Relative references to Absolute. I have used F4 to toggle to Relative but
soon as I "Apply" they convert back to Absolute.

What am I missing? Also, I'm using Office 2007.

Bob

Can I see the file?

If you want to send a copy to me I'll take a look. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

Let me know if you are going to send the file. I don't always check that
email account.

--
Biff
Microsoft Excel MVP


"robert morris" wrote in message
...
Biff,

Nothing works. Excel always changes the Relative Cells to Absolute. I've
tried everything. The range of D11:D20 changes to $D$11:$D$20 and colors
every row. I also tried Range of D11,F11,H11,J11,L11,N11. Same problem,
all cells color until one cell is selected in a Row. That Row then works
correctly one time through, then the second test run on that Row leaves
all
cells colored. I'm lost! Any more ideas?

Bob

"T. Valko" wrote:

It works for me.

Are you sure that's the correct formula you want to use?

I'm thinking you probably want to use this:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Let's assume your data is from row 11 to row 20.

Select the range D11:D20

Goto Home tabStylesConditional FormattingNew RuleUse a formula to....

Enter this formula:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Click the Format button
Select the Fill tab
Select the desired color
OK out

--
Biff
Microsoft Excel MVP


"robert morris" wrote in message
...

I have the following Conditional Formatting Formula (which works for
the
one
Row); =D11=MAX($D$11,$F$11,$H$11,$J$11,$L$11,$N$11)

Problem is I cannot copy this row down as needed. Excel always
converts
the
Relative references to Absolute. I have used F4 to toggle to Relative
but
soon as I "Apply" they convert back to Absolute.

What am I missing? Also, I'm using Office 2007.

Bob

Biff,

I just emailed it.

Bob

"T. Valko" wrote:

Can I see the file?

If you want to send a copy to me I'll take a look. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

Let me know if you are going to send the file. I don't always check that
email account.

--
Biff
Microsoft Excel MVP


"robert morris" wrote in message
...
Biff,

Nothing works. Excel always changes the Relative Cells to Absolute. I've
tried everything. The range of D11:D20 changes to $D$11:$D$20 and colors
every row. I also tried Range of D11,F11,H11,J11,L11,N11. Same problem,
all cells color until one cell is selected in a Row. That Row then works
correctly one time through, then the second test run on that Row leaves
all
cells colored. I'm lost! Any more ideas?

Bob

"T. Valko" wrote:

It works for me.

Are you sure that's the correct formula you want to use?

I'm thinking you probably want to use this:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Let's assume your data is from row 11 to row 20.

Select the range D11:D20

Goto Home tabStylesConditional FormattingNew RuleUse a formula to....

Enter this formula:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Click the Format button
Select the Fill tab
Select the desired color
OK out

--
Biff
Microsoft Excel MVP


"robert morris" wrote in message
...

I have the following Conditional Formatting Formula (which works for
the
one
Row); =D11=MAX($D$11,$F$11,$H$11,$J$11,$L$11,$N$11)

Problem is I cannot copy this row down as needed. Excel always
converts
the
Relative references to Absolute. I have used F4 to toggle to Relative
but
soon as I "Apply" they convert back to Absolute.

What am I missing? Also, I'm using Office 2007.

Bob

Ok, got the file.

I'm not real sure what you're wanting to do here.

Highlight the highest pos in each row?


--
Biff
Microsoft Excel MVP


"robert morris" wrote in message
...
Biff,

I just emailed it.

Bob

"T. Valko" wrote:

Can I see the file?

If you want to send a copy to me I'll take a look. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

Let me know if you are going to send the file. I don't always check that
email account.

--
Biff
Microsoft Excel MVP


"robert morris" wrote in message
...
Biff,

Nothing works. Excel always changes the Relative Cells to Absolute.
I've
tried everything. The range of D11:D20 changes to $D$11:$D$20 and
colors
every row. I also tried Range of D11,F11,H11,J11,L11,N11. Same
problem,
all cells color until one cell is selected in a Row. That Row then
works
correctly one time through, then the second test run on that Row leaves
all
cells colored. I'm lost! Any more ideas?

Bob

"T. Valko" wrote:

It works for me.

Are you sure that's the correct formula you want to use?

I'm thinking you probably want to use this:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Let's assume your data is from row 11 to row 20.

Select the range D11:D20

Goto Home tabStylesConditional FormattingNew RuleUse a formula
to....

Enter this formula:

=D11=MAX(D11,F11,H11,J11,L11,N11)

Click the Format button
Select the Fill tab
Select the desired color
OK out

--
Biff
Microsoft Excel MVP


"robert morris" wrote in
message
...

I have the following Conditional Formatting Formula (which works for
the
one
Row); =D11=MAX($D$11,$F$11,$H$11,$J$11,$L$11,$N$11)

Problem is I cannot copy this row down as needed. Excel always
converts
the
Relative references to Absolute. I have used F4 to toggle to
Relative
but
soon as I "Apply" they convert back to Absolute.

What am I missing? Also, I'm using Office 2007.

Bob