You didn't follow the instructions, don't know if you know what a dollar
sign in cell references mean but it means an absolute reference while one
without them is relative, so if you select from A1 to A7, A1 will be the
active cell
and it will be compared to the fixed set of cells $A$1:$A$7 so in A1 the
formula says

A1 is equal to the max value of A1:A7, in A2 it says A2 is equal to the max
value of A1:A7 all down to A7 is equal to the max value in A1:A7 and if you
set a certain format the cell with the max value (any of the cells in A1:A7)
will display that certain format. All this means that yes, the formula
works

--
Regards,

Peo Sjoblom

(No private emails please)


"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