Dec 21 2020 05:21 PM
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