| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I show up and down arrows when a value changes?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I show up and down arrows when a value changes?
Hi,
Highlight the column, do conditional formating, icon sets, choose the arrows "Julie" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SHOW AUDIT ARROWS | Excel Worksheet Functions | |||
| Up/down arrows to show trends | Excel Discussion (Misc queries) | |||
| How to show all precedent arrows on whole worksheet at same time? | Excel Worksheet Functions | |||
| Up & Down Arrows | Setting up and Configuration of Excel | |||
| Why doesn't my audit arrows show up? | Excel Worksheet Functions | |||
Linear Mode
