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 ma...
{ "$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)
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','')"
}
}
444456464 Yes I understand that, but you can format the Lundi based on the calculated column (which you can obv hide). It just another way of achieving what you want if your formatting does not work.
- Oh ok, we can do it like that, but I don't know how to do it :0