How can I show up and down arrows when a value changes?

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

I'm creating a financial spreadsheet on comparison of year-to-year and
month-to-month sales. If the sales go up from previous year, I want to show
an up arrow beside it and if it goes down, down arrow. How can I achieve
this? Can I make it an automatic thing for instance if the number is postive,
it's an up arrow and negative down arrow?
 
Hi,
Highlight the column, do conditional formating, icon sets, choose the arrows
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Query 1
How to Display Arrow for Drop Down Lists in Message Body 0
Arrows And Formulas 2
Conditional Formatting (Icon sets - 3 Arrows) 2
after inserting a "drop down box" I want the drop arrow to show 1
Function that returns symbols as formula result eg up/down arrow? 2
permenent appearance of the drop down arrow when adding validation toa cell 2
Excel 2007 Chart Data Selection- Arrow Keys Frustration 0

Back
Top