In the cells that displays the max and min, enter formulas like

=MAX(A1:A10)
=MIN(A1:A10)

but substitute your data range for A1:A10.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"jimbob" wrote in
message ...

I have a spreadsheet with cells that update in real time. Is there a way
to monitor the highest and lowest values in these cells? I would need to
output the data to another cell so that every time the monitored cells
hit a new high or low, the other cell would be updated. Thanks


--
jimbob