I have two calculated columns Variance and Variance %, they both have conditional formatting (via the SP Design Space) to turn the background green when they are less then $10K and 10% respectively.

I would like to also change the font red when the number is negative. How do I add to the JSON for this to happen?

  • 1
    Can you share your existing JSON code? I will update the same to add 2nd condition then post complete JSON as an answer. OR you can try to add code in my answer to your existing JSON. Apr 16, 2021 at 16:28

1 Answer 1


You cannot apply multiple JSON formatting codes to single column. So, you have to manage multiple conditions/rules within same JSON.

For changing color to red when number is negative, add below code in your existing JSON:


"style": {
      "color": "=if(@currentField < 0, 'red', '#323130')"


Documentation: Use column formatting to customize SharePoint


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.