Conditional formatting

Copper Contributor

I'd like to apply conditional formatting to an auto calculated column that needs to display the value as a %.  I'd like to highlight values >= 75% and <90% as yellow and values >=90% as red.  I'm unfamiliar with JSON and am unable to get the syntax correct.  I can get it to highlight the cells correctly but it displays the values as a decimal number and not a %.

4 Replies

@Walterwhamil72 this can be done as follows. In your calculated column use the following formula:

 

SPlistSettings.png

 

 The formatting of the column is then like this:

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=[$Percent]*100 + '%'",
  "style": {
    "color": "=if([$Percent] >= 0.75 , '#ffffff', '#525252'",
    "background-color": "= if(([$Percent] >= 0.75 && [$Percent] < 0.90 , '#eebf2d', if(([$Percent] > 0.90, '#730000'), '#ffffff'"
  }
}

 

which gives the following result:
SPlist.png

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Thanks for the guidance.  I followed your instructions but the column is now blank.  The column names I need in the calculation are:

 

Cumulative Invoiced/Total Value

 

The formula I'm using looks like this:

 

Formula.PNG

 My JSON looks like this:

Json.PNG

 The Burn Rate column looks like this now:

Burnrate.PNG

 Walt.

@Walterwhamil72 the reason it's not working is that in your JSON you've used my column which is called Percent. You've got to use your burn rate column name - as you've got a space in the name check what SharePoint has called it internally in List settings, select the column and check what is after field= in the address bar.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Everything is working correctly.  Thanks for your assistance.