Forum Discussion

carlblunck's avatar
carlblunck
Copper Contributor
Aug 19, 2022
Solved

Conditional formatting help

Hi community,   Just need some help with some JSON conditional formatting code.  Snip of my list, note the current result values are blank because of the JSON code issue. Current JSON script...
SharePoint Online
  • RobElliott's avatar
    RobElliott
    Aug 19, 2022

    carlblunck you've missed out the second = 

     

    It should be =='Under' etc

     

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "color": "=if((@currentField > [$Benchmark] && [$Goal]) == 'Under', 'red', if((@currentField < [$Benchmark] && [$Goal]) == 'Over', 'red', 'green')",
	"font-weight": "=if((@currentField > [$Benchmark] && [$Goal]) == 'Under', 'bold', if((@currentField < [$Benchmark] && [$Goal]) == 'Over', 'bold', 'normal')"
  }
}

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

RobElliott's avatar
RobElliott
Silver Contributor
Aug 19, 2022

ganeshsanap I'd already given the JSON code that works fine, even with the extra brackets. Be careful not to step on someone else's solution.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

ganeshsanap's avatar
ganeshsanap
MVP
Aug 19, 2022

RobElliott Thank you for your response. Did you actually tried using the JSON you provided?

 

Try using the JSON you provided & let us know the results. Thank you.

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Aug 19, 2022
    Yes I did, as I always do, and it worked perfectly.
    • ganeshsanap's avatar
      ganeshsanap
      MVP
      Aug 19, 2022

      RobElliott Great, glad it worked for you!

      And I am not trying to steal your solution. I replied to this thread only because I observed below problems with the JSON provided by OP in question. Thanks for your understanding, happy weekend!

       

       

Resources