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