Highlight if greater than all previous numbers in a series

[flizzo]

Hi all,

I'm trying to count all-time highs in the stock market, so I'm looking for a dynamic formula that looks at all previous closing index values and highlights whether or not the most recent close is an all-time high.

In the attachment here, I've got the series from early 1928 S&P index values. I added in "YES" manually for all-time highs here but looking for a formulaic solution.

Thanks in advance for any assistance here.

-Mike

[JohnTopley]

In C2

=IF(B3>MAX($B$2:B2),"YES","")

Copy down

[flizzo]

Boom! Thanks John!!