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 |
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 |
All times are GMT +1. The time now is 11:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com