I have a cell that changes values, call it cell A1. What I want to
happen, is once A1 becomes 5000, I want B1 to do something. Doesn't
matter. Turn blue show "99999", I don't care. What matters is that it
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
Paul
--
Paul987
------------------------------------------------------------------------
Paul987's Profile:
http://www.excelforum.com/member.php...o&userid=24850
View this thread:
http://www.excelforum.com/showthread...hreadid=479918