Conditional formatting value change of same cell
I have a list of stock quotes that filter down the best performing stocks every morning when the market opens. The thompson reuters program that does this directly links to excel and I can drag and drop these stocks there and have them stream in real time in excel. I have several columns of data, Open,Last,Pct.Chnge, High,Low,Close and Volume. I am trying to have column "G","High" formatted to alert me by changing the cells color when the value in the "High" cell changes.
|