If c1 is the cell with changing values, and c2 holds the value, then you
can use c1's change event to increase the value in c2.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$1" Then
If Target.Value Range("C2").Value Then
Range("C2").Value = Target.Value
End If
End Sub

Patrick Molloy
Microsoft Excel MVP
"icehot" wrote in message
...
Hi,

I have a formula in a cell currently, that is based on the value in
another cell. As the value in the other cell increases I want the
formula to be in effect and continue to calculate increasing values.

However, if the value in the other cell goes down, I no longer want
this formula to do anything, ie. the value it last calculated remains
in effect.

For your information this is to create a rising stop loss in an excel
portfolio. Hence the price may go up or down, but the stop loss
limit must only continue to rise.

Thanks,