Countdown to due date with colours green, amber and red to due date

Copper Contributor


I need to update one of my spreadsheets, so it colour codes to the due date.  Example over the course of a month week 4 to due date of vehicle service is colour coded green, 3 weeks to due date automatically changes to amber, and 2 weeks to due date changes to red.  Can anyone help me navigate this option please?

1 Reply


Conditional formatting might be what you are looking for.


This is the rule for week 4.


This is the range the formatting applies to in the example.

due date with colours.JPG