View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default Auto Change in Cell Color

I have a list of stocks like this:

Stock Price
ABC 0.35
DEF 0.35

The price updates with a DDE Link (Dynamic Data Exchange) - basically a
formula.

Is it possible to have the cell turn green if the new price is greater than
the last price and red if the new price is less than or equal to the last
price ?

Thank you in advance.