Forum Discussion
Solved
Display a value in a column with colors based on another column
Hello,
I have a list that looks like this:
I would like to use JSON code so that when the value indicated in the "Lundi" column is greater than that indicated in the "Taux occupation maximal" column, the value of the "Lundi" column is displayed in red, and that if it is lower the value is displayed in green, and if it is equal the value is displayed in orange.
But I can't do that 😞
Can you help me please? Thank you in advance !
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if(@currentField >[$Tauxoccupationmaximal] , 'red', if(@currentField <[$Tauxoccupationmaximal], 'green' , 'orange')" } }Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
6 Replies
- Could you create a calculated column to give you true or false and then base the formatting on that?
No, I have to do something like in the formatting of the Lundi column:
(But this code does not work){ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if(@currentField >[$Tauxoccupationmaximal], '#f00020',''), if(@currentField <[$Tauxoccupationmaximal], '#f008000',''), if(@currentField =[$Tauxoccupationmaximal], '#ff8000','')" } }{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if(@currentField >[$Tauxoccupationmaximal] , 'red', if(@currentField <[$Tauxoccupationmaximal], 'green' , 'orange')" } }Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
