Arrows And Formulas

[Langoose]

Hi,

I'm wondering if its possible to create a formula or some other cell
function that compares the values in two cells and draws an arrow
accordingly... for example, if we are comparing current month sales to
previous, the value in cell A could be 10 (previous month) and the value in
cell B could be 5 (current month), i.e. the number has gone down from 10 to 5
so in cell C the arrow points down and vice versa, if the number has stayed
the same the arrow is horizontal.

Any help would be greatly appreciated.

Thanks

 

[Ardus Petus]

Format cell C with font Windings 3 and enter formula:
=IF(A1=B1,"g",IF(A1>B1,"i","h"))

HTH

 

[Dav]

I had a solution given to me for something very similar in the thread
below:

http://www.excelforum.com/showthread.php?t=493445

However life is much simpler if you could use a conditional format say
if the value goes up green, down red.

Regards

Dav