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