Forum Discussion
Solved
Conditional formatting
Hi guys, How can I set the green colour for when it's '-'/negative and red when it's '+'/positive? I'm not sure if the is correct, can you please advice? Thanks!
Hi ROG,
You could try this:
if value >= 0 Number and < 100 Number then red
if value >= -100 Number and < 0 Number then green
Let me know if this works 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hello ROG ,
Set the first rule for negative values like below
1. If value is less than "0", then choose a Green color.
Set the second rule for positive values
2. If value is greater than or equal to "0" then choose a Red color.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S