Conditional formatting value change of same cell

tcalhoun · #1 04-25-2013, 07:25 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting question based on cell date	Cosmo	Excel	2	04-08-2013 12:12 PM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell	Frogggg	Excel	1	10-25-2011 08:44 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Conditional formatting of cell, Excel 2003	Scaffold	Excel	2	05-01-2010 08:56 AM