Conditional Formatting based on date range SharePoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-2008219%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20based%20on%20date%20range%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008219%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%E2%80%99ve%20been%20using%20excel%20and%20have%20an%20extensive%20list%20of%20clients.%26nbsp%3B%20Each%20client%20has%20a%20date%20in%20column%20G%20that%20represents%20and%20event%20occurring.%26nbsp%3B%20Currently%20I%20have%20some%20conditional%20formatting%20so%20that%20if%20the%20event%20is%20set%20to%20occur%20within%2090%20days%20the%20cell%20turns%20red%2C%20if%20its%20greater%20then%2090%20days%20and%20less%20then%205%20months%20it%20will%20turn%20orange.%26nbsp%3B%20The%202%20formulas%20are%20below%20and%20they%20provide%20a%20nice%20visual%20representation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETurn%20orange%3C%2FP%3E%3CP%3E%3DAND(TODAY()%26gt%3B%3DEDATE(G2%2C-5)%2CG2-TODAY()%26gt%3B90)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETurn%20red%3C%2FP%3E%3CP%3E%3DAND(G2-TODAY()%26lt%3B%3D90%2CG2%26lt%3B%26gt%3B%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20recently%20imported%20the%20excel%20list%20into%20a%20sharepoint%20list%20and%20trying%20to%20determine%20how%20I%20can%20achieve%20the%20same%20result%20using%20JSON%20or%20other%20conditional%20formatting%20on%20the%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2008219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi Everyone, 

I’ve been using excel and have an extensive list of clients.  Each client has a date in column G that represents and event occurring.  Currently I have some conditional formatting so that if the event is set to occur within 90 days the cell turns red, if its greater then 90 days and less then 5 months it will turn orange.  The 2 formulas are below and they provide a nice visual representation.

 

Turn orange

=AND(TODAY()>=EDATE(G2,-5),G2-TODAY()>90)

 

Turn red

=AND(G2-TODAY()<=90,G2<>"")

 

I have recently imported the excel list into a sharepoint list and trying to determine how I can achieve the same result using JSON or other conditional formatting on the column.

 

 

 

Any help would be appreciated

 

Thanks

0 Replies