Try =If(A<0,"p","q") (assuming A column holds your + or - numbers) then
format the column to the font 'wingdings 3'.
Then use conditional formatting to make p = green and q = red.
Sandy

"Box666" wrote in message
oups.com...
I have a front wooksheet which summaries the 4 other worksheets.

I want a quick way to show if the volumes are improving or getting
worse. So I wanted to put a bold green "up arrow" or red "down arrow"
in the relative cells, but I do not know how to achieve this. At the
moment the difference is shown as a + or - numbers.

With thanks

Bob