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



Turn red



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



0 Replies