Auto Change in Cell Color

[Guest]

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.

 

[Guest]

If you import your new prices in the next column to the right, you could
easily employ Conditional Formatting to compare it to the previous price and
set the background color accordingly.....in addition, you would have data for
a Chart, if desired.

If your new data overwrites the old data, it's much harder. Perhaps a
superprogrammer could do it in VBA by copying the old data to a helper range
doing the import, doing the comparison, coloring the cells, and then
deleting the helper range.....but it's beyond my level of expertize. If you
don't get a better answer here, you might try re-posting in the Programming
Newsgroup.

hth
Vaya con Dios,
Chuck, CABGx3