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" <jimbob.249p8m_1141681200.6427@excelforum-nospam.com> wrote in
message news:jimbob.249p8m_1141681200.6427@excelforum-nospam.com...
>
> 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