You'll need something (you???) to change the formula to a value.

Depending on what you're doing, you may be able to use a worksheet_calculate
event.

After each calculation, the range you specify would be examined. If the formula
evaluates to "completed", then the macro would change the formula to a value.

Handy wrote:

What condition can be used to keep a cells evaluation status within that
month even if it changes the next month. For example if A2 = "evaluated" in
January but changes to "completed" in February, how can you retain that
evaluated status for the month of January even after it changes during a
later month?

--

Dave Peterson