Let us say you put 105.9 in A1 today. Tomorrow you type 105.8 in A1.
Now how do you expect Excel to recall what was in the cell before you typed
the new value?
I think the problem must be re-cast.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ashish Doshi" <Ashish wrote in message
...
I want to put in a number in a cell which will change everyday, in a next
cell I want to see postive or negative diffrence, e.g. first cell may
contain 105.90 and next day if it changes to 105.80 than next cell should
show -.10, and it it is negative cell should turn red if it is positive it
should turn green in background color. Any suggestions? Thank you.