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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.......
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format and DDE..................Bet this can't be done. 17
Cell formating.......... 1
Maximum number of DDE links? 1
DDE connection 1
Event triggered in Excel's cell by DDE 3
Bloomberg DDE problem 0
Excel Need Countifs Formula Help 0
DDE link 1

Back
Top