Format and DDE.......Bet this can't be done
 

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.......

Format and DDE.......Bet this can't be done
 

Use two cells rather than one.


Store the original value of A1 in A2 and then allow A1 to update
periodically via DDE. Use Conditional Formatting on A1 to test is it is
greater or less than A2.
--
Gary''s Student - gsnu200719