Conditional formatting - dates older than 14 days

[roo181]

Hi,

I would like to be able to highlight cells in Column A if they are older than 14 days and the item hasn't been received. Refer A5
I've already highlighted cells in red that are older than 14 days, but eventually everything will turn red.
I took care of the blank cells in Column A so they wouldn't be highlighted red. (A6)

What does the conditional formatting need to be for this?

Warranty.xlsx
	A	B
1	DATE	DATE RECEIVED FROM CUSTOMER
2	1/06/2022	9/06/2022
3	11/06/2022
4	20/05/2022
5	20/05/2022	1/06/2022
6
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2	Expression	="if(today()>b2+14)"	text	NO
A2:A6	Cell	contains a blank value	text	NO
A2:A6	Expression	=A2<TODAY()-14	text	NO

Thanks for your help

 

[GraH]

No need for an IF statement, nor multiple rules in this case.

Book1
	A	B
1	DATE	DATE RECEIVED FROM CUSTOMER
2	1/06/2022	9/06/2022
3	11/06/2022
4	20/05/2022
5	20/05/2022	1/06/2022
6	18/05/2022
7	28/05/2022
8
9
10	31/05/2022
Sheet1

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

 

[roo181]

No need for an IF statement, nor multiple rules in this case.

Book1
	A	B
1	DATE	DATE RECEIVED FROM CUSTOMER
2	1/06/2022	9/06/2022
3	11/06/2022
4	20/05/2022
5	20/05/2022	1/06/2022
6	18/05/2022
7	28/05/2022
8
9
10	31/05/2022
Sheet1

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

If the item has been received by having a date in column B, I would like the cell in column A to not be red.

 

[GraH]

Then maybe

=AND($A2<>"",$A2<TODAY()-14,$B2<>"")

 

[GraH]

Sorry goof-up, it must obviously be

=AND($A2<>"",$A2<TODAY()-14,$B2="")

Book1
	A	B
1	DATE	DATE RECEIVED FROM CUSTOMER
2	1/06/2022	9/06/2022
3	11/06/2022
4	20/05/2022
5	20/05/2022	1/06/2022
6	18/05/2022
7	28/05/2022
8
9
10	31/05/2022
Sheet2

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

 

[roo181]

Sorry goof-up, it must obviously be

=AND($A2<>"",$A2<TODAY()-14,$B2="")

Book1
	A	B
1	DATE	DATE RECEIVED FROM CUSTOMER
2	1/06/2022	9/06/2022
3	11/06/2022
4	20/05/2022
5	20/05/2022	1/06/2022
6	18/05/2022
7	28/05/2022
8
9
10	31/05/2022
Sheet2

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

Awesome, thanks for your help