How have you created the big arrow and where is it located?

I am sure your request could be accommodated with some more detail.

One example.............in an adjacent cell enter this formula.

=IF(H5<0,CHAR(234),IF(H50,CHAR(233),CHAR(232)))

Format the cell to Wingdings font.

Neg will show down arrow(234), positive an up arrow(233), no change a
right arrow(232)


Gord Dibben MS Excel MVP

On Mon, 8 Dec 2008 12:52:10 -0800, Nelson B.
wrote:

I have a report for executives where I have a big "up" arrow if there was an
increase and a big "down" arrow if the amount decreased. Currently I have to
change these by hand each month. How do you automate the arrow to change
based on whether a referenced cell is pos. or neg.?

Thanks!