high and low value in a cell
 

I would like to know how to show the high value and low value of a cell that
is showing the trade by trade of a stock.

high and low value in a cell
 

It depends on how your data is organized. To get the minimum or maximum of a
range, you can use:

=min(a1:a100)
=max(a1:a100)

If your data is organized some other way, let us know.

--
Regards,
Fred


"Stock Help" <Stock wrote in message
...
I would like to know how to show the high value and low value of a cell that
is showing the trade by trade of a stock.

high and low value in a cell
 

One way:
'The low number is shown in B1, the high in C1. The changing cell is A1.
'Put 1000000 in B1 and "0" in C1 to begin
Private Sub Worksheet_Change(ByVal Target As Range)
If IsEmpty(Target) Then Exit Sub
If Target.Address(0, 0) = "A1" Then
If Target.Value < [B1].Value Then [B1].Value = Target.Value
If Target.Value [C1] Then [C1].Value = Target.Value
End If
End Sub
HTH Otto
"Stock Help" <Stock wrote in message
...
I would like to know how to show the high value and low value of a cell
that
is showing the trade by trade of a stock.