Expiration Date in Excel Coloring

[huja]

Hi.

I'm new to this forum and english is not native language so bear with me.

I really try to figure out an easy way in excel to show me when a deadline is approaching.

So let's say I have a deadline 2022-01-31, and I type 2022-01-31 in a cell.
I want excel to turn the cell red when it reaches 2022-01-31 and keep showing red after 2022-01-31.
I also want excel to turn the cell yellow when it is 14 days left until deadline.
When it is more than 14 days left I want the cell to be green.

How do I do this in Excel? I have searched everywhere and I fail every time.

I know I can use "conditional formatting" but I do not know what formula to apply to make it work.

Thanks in advance.

 

[huja]

I don't understand what you mean by revere it.

Here's a list of dates which should cover all scenarios. Please identify the colour required for each:

For the sake of argument lets say today, 11-jan-22, is the deadline date, so:
From row 7 to row 12 (date 11-jan-22 to 02-feb-22 and later): Color RED.

From row 6 to row 4 (date 10-jan-22 to 28-dec-21): Color YELLOW.

From row 3 to row 2 (date 27-dec-21 to 20-dec-21 and earlier): Color GREEN.

 

[Toadstool]

For the sake of argument lets say today, 11-jan-22, is the deadline date, so:
From row 7 to row 12 (date 11-jan-22 to 02-feb-22 and later): Color RED.

From row 6 to row 4 (date 10-jan-22 to 28-dec-21): Color YELLOW.

From row 3 to row 2 (date 27-dec-21 to 20-dec-21 and earlier): Color GREEN.

Then this should be what you want.

Huja.xlsx
	A
1	Date
2	20-Dec-21
3	27-Dec-21
4	28-Dec-21
5	29-Dec-21
6	10-Jan-22
7	11-Jan-22
8	12-Jan-22
9	24-Jan-22
10	25-Jan-22
11	26-Jan-22
12	02-Feb-22
13
2nd

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A20	Expression	=AND($A2<>"", $A2<TODAY()-14)	text	NO
A2:A20	Expression	=AND($A2<>"",$A2<TODAY(),$A2>=TODAY()-14)	text	NO
A2:A20	Expression	=$A2>=TODAY()	text	NO

 

[huja]

Bingo.
Thank you very much!

 

[Toadstool]

Bingo.
Thank you very much!

You're welcome.