I have a small requirement which can be fulfilled through JSON column formatting but I do not not know how to go about it.
Currently I have three columns
1. Consumed quantity : 12(example value)
2. Returned value : say 10(example value)
3. Returned status( calculated value) : 12-10 = 2
Now what I want is to highlight the returned status green when the difference equals 0 and if it is greater than that then it should display Color red.
If you do know please help me out. Thanks.