Clear Cell based on event w/o macro?

P

Paul987

How can I clear a cell based on an event, without a macro.

For instance if A1=B1, then C1=0? Ideas?

Thanks
Paul
 
P

Paul987

I have a cell that changes values, call it cell A1. What I want t
happen, is once A1 becomes >5000, I want B1 to do something. Doesn'
matter. Turn blue show "99999", I don't care. What matters is that i
needs to maintain that condition even if A1 once again becomes <5000.
This is why I can't get a formula or conditional formating to work
because once if A1 becomes > 5000 for a bit, and then changes to <5000
the formatting disappears. Any Ideas? Thanks

Pau
 
Top