Hi all, may I know is there a way to conditional format the [Due Date] field natively. Currently, the [Due Date] field turns ReD if the checkbox is unchecked when due date has passed or Green if the checkbox is checked. What I want is for the [Due Date] to turn Green if due date is more than 7 days away; Amber when between 7-2 days; Red when due date is less than 2 days away.
I added Amazing Fields (act like custom fields) from Power-Ups, which allows conditional formatting. But I find that becomes an unnecessary duplication. I have attached a pic, hope it provides better explanation of what I want. Many thanks.
