Hi
have a look at
http://www.mcgimpsey.com/excel/accumulator.html
for creating an accumulator (you may use a different event, e.g.
worksheet_calculate instead of worksheet_change)

P.S.: also please don't multipost as this scatters your answers and
create additional effort for all who answer to your questions
--
Regards
Frank Kabel
Frankfurt, Germany

Bob Chapman wrote:
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