View Single Post
 
Old 04-25-2013, 07:25 AM
tcalhoun tcalhoun is offline Windows 8 Office 2013
Novice
 
Join Date: Apr 2013
Posts: 1
tcalhoun is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Terry's excel quotes list.xlsx (26.0 KB, 20 views)
Reply With Quote