Forum Discussion

dmann1's avatar
dmann1
Copper Contributor
Jan 07, 2026

Conditional formatting in SharePoint lists using JSON

I have my conditional formatting working if I only refer to one number. As can be seen in the image below if the cell I want to format has the number "1" in it the formatting works.   I would l...
microsoft 365
microsoft lists
sharepoint
Kidd_Ip's avatar
Kidd_Ip
MVP
Jan 08, 2026

I recalled SharePoint JSON column formatting doesn’t use Excel-style =IF() syntax. Instead, it relies on expression objects with operator and operands.

  • Rob_Elliott's avatar
    Rob_Elliott
    Silver Contributor
    Jan 08, 2026

    Kidd_Ip​ not so. I have answered this on his duplicate post here and used if() syntax.

    Rob
    Los Gallardos
    Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

    • dmann1's avatar
      dmann1
      Copper Contributor
      Jan 09, 2026

      Sorry for the double post. I had looked for the first post and could not find it. I will comment on the other post.

Resources