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

Рет қаралды 29,543

3 жыл бұрын

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/palettes/trending
colorhunt.co/

Пікірлер: 17

@noorshaikh8527 Жыл бұрын

This was a quick fix, very helpful. Thanks

@SOMETIPSREVIEWER 2 жыл бұрын

THANK YOU ,very much helpful video

@jhtrkhgvtkuyejh Жыл бұрын

Thank you! my reports looks much better now ;)

@way8380 2 жыл бұрын

thank you so much .. you saved me

@John-jt3dn 2 жыл бұрын

Kudos for writing the formula...

@bearhzza 2 ай бұрын

thank you for sharing the tips, that's helpful

@jshahful Жыл бұрын

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

@walterpenalopez6230 Жыл бұрын

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

@EvaQiu-rd8st 3 ай бұрын

Thank you!

@Imp-bq6iy 9 ай бұрын

Thank you so much, it was really helpful!

@learningshark8059 8 ай бұрын

Glad it helped!

@murataksu6496 5 ай бұрын

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!

@niccolbuenamente9473 Жыл бұрын

THANK YOU DO MORE GOOGLE SHEET TIPS

@dannykeough8474 2 жыл бұрын

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

@evanmccormick4816 2 жыл бұрын

instead of [Green], you can use [Color10] for a darker green

@digeshwarsahu23 Жыл бұрын

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