Conditional Formatting based on date range SharePoint List

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