Clear Cell based on event w/o macro?

  • Thread starter Thread starter Paul987
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Help needed 0
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
Scrabble Value calculation for Welsh words 0
How do I clear 'form' content from an unprotected cell without mac 4
Function for summing or counting cells based on a specified fill color 2
setting cell values based on a 3rd cell 4
Creating macro 9

Back
Top