Hi Mike

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

work?

Cheers
JulieD

"Mike" wrote in message
...
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