So, I thought I was pretty decent at this excel stuff - far above the average Joe, at least. Then I came to this site, and had a real eye-opener! I don't know anything compared to all of you! Hopefully I will soon enough though! Anyway, on with my question...
I've attached an image of a chart that I have at work. (BTW, if I attached it wrong, I'd love it if someone could fix it for me, or at least tell me how to do so)
So anyway, the chart has the arrows in it, but they aren't a formula. They're copied and pasted in manually.
What I'm looking to do is automate the arrows.
- If the change from last week is > 0, I would like it to show a green up arrow.
- If the change from last week is < 0, I would like it to show a maroon down arrow.
- If the change from last week is = 0, I would like it to show a grey dash (-).
excel question.jpg
conditional_formatting_question.xlsx
I think I have to do something with conditional formatting, but I'm in over my head.
Thanks, everybody!
Last edited by mam04x; 02-25-2010 at 01:27 PM.
Welcome to the forum
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
No color, but try this spreadsheet...
Last edited by sandz23; 02-25-2010 at 01:40 PM.
Thank you. That was extremely helpful. That will work temporarily.Originally Posted by sandz23
I still need to get color into it though - so if anybody could now help me do that I'd really appreciate it.
In your example, in C14, dragged rightEnter Conditional Formatting>New Rule> Using FormulaCode:=IF(ROUND(C13,2)>0,"↑",IF(ROUND(C13,2)<0,"↓","-"))
=ROUND(C13,2)>0 and set formatting to bold green.
Repeat with formulas for <0 and =0.
Does that work for you?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
I got it to work!
Thank you, everybody! My team is going to be impressed! Excel Forum will forever have a place in my bookmarks menu!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks