Forum Discussion

Czyz0's avatar
Czyz0
Copper Contributor
Jan 06, 2023

Change field BACKGROUND color based on value of ANOTHER field drop down

I'm using the JSON formatting field on column ESTVal, which is a number field.  I want to show a background of GREEN when the selection in STATVal is Committed.  I'm trying this JSON and see no forma...
sharepoint server
RobElliott's avatar
RobElliott
Silver Contributor
Jan 07, 2023

Czyz0  add the txtContent": "@currentField" line as shown below and make sure that your #FFA07A has a closing single quote which it doesn't at the moment. The correct JSON is:

 

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if([$STATVal] == 'Committed','#FFA07A', '' )"
  }
}

 

 

 

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

  • Czyz0's avatar
    Czyz0
    Copper Contributor
    Jan 09, 2023
    I'm still not seeing any change to my background for the field. 😕
    • RobElliott's avatar
      RobElliott
      Silver Contributor
      Jan 09, 2023
      What's your current JSON code looking like now you've made the changes. And if you could give a screenshot of your view of the list...

Resources