Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to add an arrow
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to add an arrow
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow font | New Users to Excel | |||
How to do the following by pressing the down arrow or up arrow key? | Excel Discussion (Misc queries) | |||
arrow keys | Excel Discussion (Misc queries) | |||
dashes and the right arrow key | Excel Discussion (Misc queries) | |||
using dashes and the arrow key | Excel Discussion (Misc queries) |