conditional format depending on value in multiple columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2158432%22%20slang%3D%22en-US%22%3Econditional%20format%20depending%20on%20value%20in%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2158432%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20JSON%20but%20I%20figured%20that%20is%20what%20I%20need%20to%20use.%20I%20have%20tried%20to%20look%20on%20different%20forums%20and%20guide%20but%20can't%20find%20out%20how%20I%20can%20accomplice%20what%20I%20am%20after.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20with%204%20columns%20StartDate%2C%20ApplyFrom%2C%20EndDate.%20I%20want%20to%20evaluate%20all%20this%20columns%20in%20to%20a%20separate%20column%20named%20Progress.%20Where%20if%20any%20of%20the%20dates%20in%20the%203%20columns%20are%20today%20-10%20days%20will%20give%20Green%20color%2C%20and%20if%20the%20today%20-3%20days%20Yellow%2C%20and%20if%20today%20orange%2C%20If%20today%20%2B1%20day%20red.%20Once%20it%20passed%20today%20%2B5%20days%20it%20should%20have%20no%20color.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EMaybe%20this%20isn't%20possible%20and%20I%20am%20asking%20to%20much.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20or%20hint%20is%20appreciated%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2158432%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi, 

 

I am new to JSON but I figured that is what I need to use. I have tried to look on different forums and guide but can't find out how I can accomplice what I am after. 

 

I have a SharePoint list with 4 columns StartDate, ApplyFrom, EndDate. I want to evaluate all this columns in to a separate column named Progress. Where if any of the dates in the 3 columns are today -10 days will give Green color, and if the today -3 days Yellow, and if today orange, If today +1 day red. Once it passed today +5 days it should have no color. 

Maybe this isn't possible and I am asking to much. 

 

Any help or hint is appreciated 

0 Replies