Conditional Formatting with Dates

[DavidKA]

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.

Name	Draw Number	Date To Be Paid
Jim	1	16/1/23
Mike	2	3/1/23
Jason	3	18/1/23
Max	4	23/1/22
Sam	5	2/1/23
David	6	31/1/22

Any help would be gratefully appreciated.

[#2]

@DavidKA 

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.

[#3]

@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

[#4]

@DavidKA 

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