| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional statments.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula - language needed | Excel Worksheet Functions | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
| How do i create a conditional sum? | Excel Worksheet Functions | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
