If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
hit counter question
I need a hit counter on Excel 2003 which counts the number of times a
condition is met. This spreadsheet DDEs to RediPlus (trading software). The DDE fields would be "last price" and "day high price". When last = day high, I have it flash a green conditional format. What I would like to do is to not only flash green but also count the number of times last = day high. For example, A1 = DDE link to "last price" of IBM (constantly changing) B1 = DDE link to "day high price" of IBM (changes only when a new high is made otherwise stays the same) C1 = alert if they equal (IBM is making a new high) - flashes green via condiitional format I would like to put a hit counter in C1 that only increases when last = day high Seems simple, but I just can't get it to work Thanks Bob |
Thread Tools | |
Display Modes | |
|
|