Need help with If statement

[mike]

1


A B C D
1 Symbol: Last: Limit: Status:
2 IBM-US 105.28 105 open


Cell D2 =IF(C2>=B2,"filled","open")

Cell B2: is connected to a price quote feed and
fluctuates in price (up and down) always
changing.

Cell C2: is a manually entered price that remains
constant (unless changed).

Based on the cell formula in cell D2 it works
well - status will change from "open" to
"filled."
Problem: However if the price in cell B2 were to move
up again the status would change back from
"filled" to "open."
Question: How do I keep the status from changing back
from "filled" to "open." In other words the
status can only go from "open" to "filled" and
remained as "filled" regardless of what happens
in cell B2 afterwards.

Thank you in advance

 

[Patrick Molloy]

use the sheet's calculate event to check the cell value ... right click the
sheet tab, select View Code from the popup and paste this:

Option Explicit
Private Sub Worksheet_Calculate()
If Range("D2") = "filled" Then Range("D2") = "filled"
End Sub

NOTE - this removes the formula and replaces it with the text.