Hi!

This isn't doing anything.

Describe the *EXACT* steps that you performed. What formula did you use?

Also, it seems you are forcing one
particular cell to represent the highest value (A1).

No, not at all. When you select the range of cells and apply the CF formula:

=A1=MAX(A$1:A$7)

The reference to A1 is relative and applies only to that cell. The reference
automatically changes with each cell in the selected range.

This does work. I've done it litterally tens of thousands of times!

Biff

"brett" wrote in message
oups.com...
This isn't doing anything. Also, it seems you are forcing one
particular cell to represent the highest value (A1). Any cell in 1
thru 7 can have the highest value and that particular cell should be
colored. Not some other cell.

Thanks,
Brett