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