On 5 May, 19:16, sonicscooter
wrote:
Hi,i don't think this can be done,but if you can prove me wrong i would be
gratefull.....If i have a cell say A1 which is linked to another cell which
has a DDE link to another program,this is to do with share price data,what i
want is ,if the number in cell A1 is 100 and then changes to say 101,because
the new number is higher than the original (100),is it possible for the new
number to be blue in colour and if the new number is say 99 ie less than the
original to be red?...Im sure you will know what i mean from the way you see
share price programs work on television,say on Bloomberg for example.......


I don't know about the DDE link to another program bit, but if there
is a "refresh DDE link" routine which is coded in VBA, then as part of
this refresh:

Column A (hidden) stores old values
Column B (visible) stores new values

1. Copy Column B to Column A (update the "old values - use copy....
pastespecial...values)
2. Store the new values in Column B (from your link)

If you have the conditional formatting of the Column B setup based on
comparing Column A vs Column B, it should now show in blue / red
depending on your preferences.

HTH

Andrew