Conditional Format Stumper

[Guest]

I have a sheet of live stock quotes. Currently, when the high price and last
price equal each other, I know the stock is at the high of the day, so I set
the conditional format to change to bright green.

What I would like to do is figure out how to change the high and last to
bright green, ONLY when a new high is reached. So if the stocks trades
multiple times at the high of the day, the color does not change. It would
only change if a new high was made.

Any suggestions would be appreciated.

thanks!
Mike

 

[JulieD]

Hi Mike

would a CF formula such as
=AND($C4=$B4,$C4=MAX($C$3:$C$100))

work?

Cheers
JulieD

 

[Guest]

Thanks Julie, but that would not work as I do not capture (record) every
price change which I assume is what your formula assumes for in the max
statement. The easiest way to explain this is if the cell that contains the
high price changes we know it is a new high and should highlight the cell
green when it also equals the last price.

To repeat, high needs to change AND equal last. I can not figure out how to
determine that high has changed.

Mike