Solved

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

Posted on 2011-02-10
15
284 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Maliki Hassani
  • 7
  • 5
  • 3
15 Comments
 
LVL 33

Expert Comment

by:jppinto
Comment Utility
Do you have Excel 2010?
0
 

Author Comment

by:Maliki Hassani
Comment Utility
No 2007.  :(
0
 
LVL 33

Assisted Solution

by:jppinto
jppinto earned 50 total points
Comment Utility
You can do it with Conditional Formatting in Excel 2010.
Capture.JPG
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 450 total points
Comment Utility
How's this?
Example--2-.xlsx
0
 
LVL 33

Expert Comment

by:jppinto
Comment Utility
I'm note sure if Excel 2007 has this feature...can you please check?
0
 

Author Closing Comment

by:Maliki Hassani
Comment Utility
Thanks!
0
 

Author Comment

by:Maliki Hassani
Comment Utility
rorya:  Any idea on how to get a red arrow down?
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
Not with a formula. The whole thing would have to be red.
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
Or you'd have to use a separate cell, of course.
0
 

Author Comment

by:Maliki Hassani
Comment Utility
Thanks
0
 

Author Comment

by:Maliki Hassani
Comment Utility
Could you show me an example of the seperate cell?
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
Here you go. I added conditional formatting to make them red when the down arrow applies.
Example--2-.xlsx
0
 

Author Comment

by:Maliki Hassani
Comment Utility
Disregard..  It won't show color if it is being pulled into a combo box anyway..  :(
0
 

Author Comment

by:Maliki Hassani
Comment Utility
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..
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
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. :)
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now