Change colour based on DDE data

**neoen** · 06-10-2009, 05:18 PM

Hello,

is it possible to automatically change background colour based on realtime DDE data?
These data are from broker (stock prices) and when price is higher I would like to have green background and when price goes lower then I would like to change it to red.
I could not find anything, so any help is very appreciated.
Thank you very much...

**starryknight64** · 06-10-2009, 05:36 PM

First off, you would need a good way to obtain real-time data... not sure I can help you there...

As for changing color, now that's something do-able (at least by me). Take a look at conditional formatting in these forums, you may find something of use.

**neoen** · 06-10-2009, 05:47 PM

Thank you for your answer. I tried to catch one value from DDE with DoEvents, but I do not know how to check all values...

Also I did not find any conditional formatting example related to change colour when some value is rising (there is no percent, range to define, only rising / falling condition). And I am totally stuck :-(

**starryknight64** · 06-10-2009, 06:17 PM

Try changing the conditional formatting of one cell to check on a function:

Please Login or Register  to view this content.

Where B2 is the new data and B3 is the old (or vice-versa could work as well).

**neoen** · 06-10-2009, 06:44 PM

Yes, I did not emphasize it, but this changing (rising / falling) value is only in one cell (realtime changed value through DDE technology)...

**starryknight64** · 06-10-2009, 06:58 PM

Then copy the previous value to B2 and put the present value into B3 and rinse and repeat.

You may also want to look into looking at trends--which means conditional formatting may be harder to do... (since you'll be keeping older data than just the previous one).