Conditional Formatting on Live Feed Cell

[slimimi]

Hi there - using excel 2003.
I am using DDE to get currency prices from MT4 platform.

formula in cell D3 is =MT4|ASK!EURUSDm

I am trying to do a conditional format so that colors change depending on whether price has moved up (blue) or down (red)

I thought i could go to Conditional format and do the following :

If Cell Value (greater than) =D3 then turn blue
and
If Cell Value (less than) =D3 then turn red

this didn't seem to work.

Anybody have any ideas?

Do i need to include something in the formula which looks at (old cell value)???

Thanks in advance.

 

[Andrew Poulsom]

You will need to store the previous value. Here is an example:

http://www.oaltd.co.uk/DLCount/DLCount.asp?file=Previous.zip

 

[slimimi]

Thanks Andrew but i am still not quite sure how to apply this.

Can you tell me please - in VB - is there not a code that represents OldCellValue?

Thanks in advance.

 

[Andrew Poulsom]

Thanks Andrew but i am still not quite sure how to apply this.

Can you tell me please - in VB - is there not a code that represents OldCellValue?

Thanks in advance.

No, there isn't such a property.