How to Use Increase Decrease Arrows in Excel

How to Use Increase Decrease Arrows in Excel

In this video we have a look at how we can insert symbols in Excel, copy those symbols using CTRL + C and then paste the symbols in our custom number format type field. In this video we use up arrows and down arrows (increase/decrease) to show the change between data sets based on percentages outlined. Negative numbers show with a down arrow and positive numbers show with an up arrow. We also show you how to use conditional number formatting within custom number formatting using square brackets.

-~-~~-~~~-~~-~-
Checkout my newest video: "How to Use the Vlookup Formula in you Excel Dashboard"
-~-~~-~~~-~~-~-

[demis]

This is good but when you use this formula, you will still get a decrease/increase icon when there's no change. the 0% will show either red or green. I dont know how to fix it.

[RocsGirl]

it has been more than 15 years since I used excel in this "in depth" method, usually using it for quick home or travel budgeting. I'm no longer on the outside of that conversation :) I need to get back into the field. nerds make the world go 'round <3

[juliakristavilladiego]

Great, super quick but very helpful. Thanks!

[PhillipChristiansen]

This is just genius. And the video is concise and simple. Love it. Thank you for great content.

[ksenianewton]

Great video! Thanks for sharing. I've watched it a few times today already because i can't remember the steps.

[wwsnisn]

Love the tools... boss asked for some additional visuals and this was a very easy embellishment!!!

[deepakmehra]

Excellent Video. Crisp, clear and brief. Thank you very much. Just in case if green color seems to be very sharp, type [Color10] instead for a smooth green color. Have a great day.

[daverohitb]

Just what I was looking for. Perfect, thanks

[sethsusheel]

WoW... Always wanted to do this in excel. Thank you

[guruprasadbm]

Thank you for sharing this video... I have 1 doubt "if value is negative result should show Loss, otherwise Profit".
Is it possible..? Is there any formula.?

[ParveenKumar-zllt]

sir, i want to show some symbol for no change in the values along with increase or decrease arrow symbols. How should I do? Please help

[ganeshmadhyastha]

Can you please tell me how to use this option for $ values?

[krishnaseshadri]

excellent series however in this video i have a suggestion, kindly note green and Red text needs to be captured in Sq Brackets else it errors( Excel 2007), in your Video the same is not mentioned nor well visible.

[jobsqatar]

how to show green and red based on particular cell value ? if the current cell value is less we need a red decrease button. can you please assist?

[freeeducationforall]

What a wonderful video. I just need one thing can we have it without changing the font color of the value itself? I want numbers to be written in black and arrows to be in green and red. Is it possible?
Thanks in advance

[xzgryhm]

Hi Brad, how do we keep
color for the number black and the red and green for arrows?

[slinger]

is there a way where i can only color code the symbol arrows and not the values?

[grammakov]

Can I use Icon sets conditional formatting for that?

[ManojKumar-spbn]

What if I want to show only the arrow in color?

[Illiakubasov]

Can i use specific cell ( A2, D17 or any other) in the Custom Format? I want to draw arrow based on absolute value of another cell.