Link to home
Start Free TrialLog in
Avatar of Maliki Hassani
Maliki HassaniFlag for United States of America

asked on

Excel: Truncated formula but show image of aroow up and down based on %

Experts!

I have spreadsheet with truncated formulas that will show the indicator name , the percentage and now I would like to show an arrow pointing up or down based on what the percentage is.  This is going into a dashboard so I though this would be good to include. Example.xlsx

FYI:  In the dashboard the surveillance tab under Weekly Performance Delta is what I am working with.
NOC-Reports-r9.xlsm
Avatar of jppinto
jppinto
Flag of Portugal image

Do you have Excel 2010?
Avatar of Maliki Hassani

ASKER

No 2007.  :(
SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'm note sure if Excel 2007 has this feature...can you please check?
Thanks!
rorya:  Any idea on how to get a red arrow down?
Not with a formula. The whole thing would have to be red.
Or you'd have to use a separate cell, of course.
Thanks
Could you show me an example of the seperate cell?
Here you go. I added conditional formatting to make them red when the down arrow applies.
Example--2-.xlsx
Disregard..  It won't show color if it is being pulled into a combo box anyway..  :(
That is awesome.. but do you know what type of box or list of some sort that will pick up color?

The combo box is on a different page..
If you use a listview you can add icons to it but you would have to create the image files. It's also a lot of faffing about for not much result, IMO. :)