In my SharePoint list I have a column of review dates. I was wanting to create a formatting formula which, I have tried using Co-Pilot to various levels of success I want the standard DD-MM-YY in the following colours
In excess of 30 Days in the future – Black on White background
Less than 30 days into the future – Red on light orange/Yellow background
In the Past – Bold White on Red Background.

Any help would be appreciated

​In my SharePoint list I have a column of review dates. I was wanting to create a formatting formula which, I have tried using Co-Pilot to various levels of success I want the standard DD-MM-YY in the following coloursIn excess of 30 Days in the future – Black on White backgroundLess than 30 days into the future – Red on light orange/Yellow backgroundIn the Past – Bold White on Red Background. Any help would be appreciated  Read More

​