Conditional Formatting with Dates

Copper Contributor

Could anyone help me with the formula so I can enter in conditional formatting. 


What I’d like to do is have the third column flag up when someone’s date is approaching with say 2 weeks notice (turns amber) and then turns red when the date has passed so I know they need to arrange a further payment.


NameDraw NumberDate To Be Paid




Any help would be gratefully appreciated.
3 Replies


Here are some links to do it yourself  :).

The learning experience is extraordinarily larger than the ready-made solution.


Use conditional formatting to highlight information

Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values

How to conditional formatting based on date in Excel?

 As we known, the Conditional Formatting can auto change cell format based on the cell contents. This upper link, I will introduce how to conditional formatting cells based on date in Excel.

@NikolinoDE Thank you !!! I have tried but I am not sure is it right or not, can you confirm 




Amber =TODAY()+14<C2

Red =AND(TODAY()>C2,C2<>"")


Looking forward


Here is an example file...

If it's over the date, then RED

If it is between 1 day and 14 days before the date then YELLOW

If it is 15 days before the date WHITE