Display a value in a column with colors based on another column

%3CLINGO-SUB%20id%3D%22lingo-sub-3192569%22%20slang%3D%22en-US%22%3EDisplay%20a%20value%20in%20a%20column%20with%20colors%20based%20on%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3192569%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI%20have%20a%20list%20that%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22444456464_0-1645441941396.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349953i1334DAC6D602E289%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22444456464_0-1645441941396.png%22%20alt%3D%22444456464_0-1645441941396.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20use%20JSON%20code%20so%20that%20when%20the%20value%20indicated%20in%20the%20%22Lundi%22%20column%20is%20greater%20than%20that%20indicated%20in%20the%20%22Taux%20occupation%20maximal%22%20column%2C%20the%20value%20of%20the%20%22Lundi%22%20column%20is%20displayed%20in%20red%2C%20and%20that%20if%20it%20is%20lower%20the%20value%20is%20displayed%20in%20green%2C%20and%20if%20it%20is%20equal%20the%20value%20is%20displayed%20in%20orange.%3C%2FP%3E%3CP%3EBut%20I%20can't%20do%20that%20%3A(%3C%2Fimg%3E%3CBR%20%2F%3ECan%20you%20help%20me%20please%3F%20Thank%20you%20in%20advance%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3192569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hello,
I have a list that looks like this:

444456464_0-1645441941396.png

 

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 !

0 Replies