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
Sandy - 08 Mar 2007 23:41 GMT
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
>I have a front wooksheet which summaries the 4 other worksheets.
>
[quoted text clipped - 6 lines]
>
> Bob