• 463K Members
• 6,572 Online
• 560K Conversations
SOLVED

New Contributor

# How to make "monitor change"?

Hello everyone. Maybe it's a hard question, like my english :D. I'll try explain what I need.

I need to know how to write formule for that:

I have in one row number 100

In other row number 50

In 3rd row number 200

So in next column, in same rows, I want to have different in percents. For example

2nd row is 50 percent lower, so it says 50% (and take red text color)

3rd row is 400 percent higher then 2nd row, so it says 400% (and green text color).

Really need help on that :).

4 Replies
Solution

# Re: How to make "monitor change"?

@Bucketin , you may do like this

applying conditional formatting to second column with red if value is less than 1 (100%) and red otherwise

# Re: How to make "monitor change"?

This working wrong. For example
1. 200
2. -500 and it shows -250%. It's wrong.

# Re: How to make "monitor change"?

It depends on how do you calculate per cent. If as A2/A1 (as in your first post 200 is 4 times higher than 50, thus 400%), when 500/200 = 250%

If as ABS(A2-A1)/A1 when (500-200)/200=150%. It could be other definitions. What is correct result in this case?

# Re: How to make "monitor change"?

Ahh nvm.. I tried many ways when number have - sign and always it show wrong calculations. I made it just simple different without percents. Thank you.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies