Not possible without a macro.

--
Biff
Microsoft Excel MVP


"darklyndsea" wrote in message
...
Is there any way to automatically replace a formula with its value when a
condition is met, without the user changing it manually? I'm not talking
about macros, but rather, for instance, if NOW()=A2 then the value in A3
stops changing.