How to use or add increase or decrease trend arrows in GOOGLE SHEETS
HTML-код
- Опубликовано: 11 сен 2024
- 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
coolors.co/pal...
colorhunt.co/
thank you for sharing the tips, that's helpful
Kudos for writing the formula...
Thank you! my reports looks much better now ;)
This was helpful. What about for Zero? No Increase/Decrease how can I find the forward arrow?
Thank you!
This was a quick fix, very helpful. Thanks
Thank you so much, it was really helpful!
Glad it helped!
thank you so much .. you saved me
THANK YOU DO MORE GOOGLE SHEET TIPS
THANK YOU ,very much helpful video
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!
Hello, thanks for this. Is there anyway to just have the arrows coloured in red or green and kept the text black ? thanks
How do you change the lime green color in this formula to a darker green?
instead of [Green], you can use [Color10] for a darker green
How to change the colors from green and red? Or different shades of red and green?
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