Conditional Format Stumper
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
|