Forum Discussion
adam_tcp
Dec 22, 2020Copper Contributor
Conditional Formatting based on date range SharePoint List
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
No RepliesBe the first to reply