I want to change the value of cell-A conditioned on the value of another
cell, however if the condition fails I want the value of cell-A to be
unchanged.

In other words, I want cell-A to remember the value from the last time the
condition was met.

It sounds like setting a global variables might accomplish this, but I don't
think Excel has this capability.

I don't know VBA.

Any ideas?