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.
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.