How to use or add increase or decrease trend arrows in GOOGLE SHEETS

How to add trend arrows in GOOGLE SHEETS
Formula: [Green]▲ 0.00%;[Red]▼ -0.00%
for Increase is good (Green) & decrease is bad (Red)

[Red]▲ 0.00%;[Green]▼ -0.00%
for Increase is bad (Red) & decrease is good (Green)

Step 1: Select the data range then Go to Format then click ➡ Numbers then scroll down to ➡More formats then ➡custom number format

Step 2: Add the formula and click apply
Note for using it for numeric figures remove the %

Addon: Color template website links

[walterpenalopez]

This was helpful. What about for Zero? No Increase/Decrease how can I find the forward arrow?

[bearhzza]

thank you for sharing the tips, that's helpful

[jhtrkhgvtkuyejh]

Thank you! my reports looks much better now ;)

[noorshaikh]

This was a quick fix, very helpful. Thanks

[murataksu]

Thanks for video. How can I use these arrows with currency and commodities when they change? Because it's currency value but these arrows are working as custom number?! When I apply this formula, currency is gone and just having as numbers. TIA!

[jshahful]

Hello, thanks for this. Is there anyway to just have the arrows coloured in red or green and kept the text black ? thanks

[Imp-bqiy]

Thank you so much, it was really helpful!

[dannykeough]

How do you change the lime green color in this formula to a darker green?

[jefefumador]

How to change the colors from green and red? Or different shades of red and green?

[digeshwarsahu]

I want to create a custom number format to change colour green if the given number is between 70% to 99%, pink if the given number is 100% and if it is below 70% then it show red colour. What will the formula for Google sheet not for Excel