Unable to obtain relative reference using conditional formatting

[JP]

To replicate in Excel 2007:

A1: 2
A2: 1
A3: 3
Select cells A1:A3, with A1 being primary
Conditional Formatting
New Rule
Use a formula to determine which cells to format
=A1=MAX(A$1:A1)
Format, Bold, OK
OK
Cells A1 and A3 are bold, as they should be.
Select cell A2
Conditional Formatting
Manage Rules

See that the Rule formula is identical to what was typed in A1; it did not
adjust. The same is true with A3, even though they are all working correctly
as if they did, in fact, adjust. This is very disconcerting when checking
conditional formulae in a very large spreadsheet.
Am I doing this correctly? What is going on here?

Thank you in advance for your assistance.

JP

 

[T. Valko]

This is very disconcerting when checking conditional

formulae in a very large spreadsheet.

I couldn't agree more!

What is going on here?

That's just the way MS did it. Nothing you did was wrong and there's nothing
you can do about it.

 

[JP]

Thanks, Biff, and best regards,
JP

I couldn't agree more!


That's just the way MS did it. Nothing you did was wrong and there's nothing
you can do about it.