How to add an arrow

  • Thread starter Thread starter Box666
  • Start date Start date
B

Box666

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
 
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
 
Back
Top