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
https://coolors.co/palettes/trending
https://colorhunt.co/
Видео How to use or add increase or decrease trend arrows in GOOGLE SHEETS канала Learning Shark
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
https://coolors.co/palettes/trending
https://colorhunt.co/
Видео How to use or add increase or decrease trend arrows in GOOGLE SHEETS канала Learning Shark
Комментарии отсутствуют
Информация о видео
30 июля 2021 г. 23:13:49
00:02:39
Другие видео канала