[SOLVED] Trouble with conditional formatting referencing an alternative cell.

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!

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.

No color, but try this spreadsheet...

In your example, in C14, dragged right

Please Login or Register  to view this content.

Enter Conditional Formatting>New Rule> Using Formula
=ROUND(C13,2)>0 and set formatting to bold green.
Repeat with formulas for <0 and =0.
Does that work for you?