Conditional formatting

[sfortin57]

I want the worksheet to highlight the dates that are more than 300 days old in orange and the ones over a year ol

test.xlsx
	D
2	DATE
3	3/6/2020
4	2/27/2019
5	11/25/2019
6	4/1/2019
7	4/8/2019
8	3/3/2019
9	1/26/2020
10	2/10/2020
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D32	Expression	=D3<=TODAY()-365	text	YES
D3:D32	Expression	=D3<=TODAY()-300	text	NO
D3:D32	Cell	does not contain a blank value	text	NO

 

[Eric W]

Welcome to the forum.

It looks like you've pretty much got it, except I'd add another condition so that unfilled cells don't get formatted.

Book1
	D
1
2	DATE
3	3/6/2020
4	2/27/2019
5	11/25/2019
6	4/1/2019
7	4/8/2019
8	3/3/2019
9	1/26/2020
10	2/10/2020
11	3/1/2018
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Sheet12

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D32	Expression	=AND(D3<>"",D3<=TODAY()-365)	text	NO
D3:D32	Expression	=AND(D3<>"",D3<=TODAY()-300)	text	NO

 

[sfortin57]

perfect. thanks