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