Need Conditional Formatting Formula to Change the Highlight to Red if today is more than 5 years past sticker date and yellow if it is 4 years past

[Nlhicks]

Arc Flash Tracking 2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Substation	Date Stickered	Stickered By	Due Date			Field Comments
2	Bole	2026	G.Giant	2031			Gotta love those veggies
3	Circle	2024	N. Hicks	2029
4	Conrad	2024	N. Hicks	2029
5	Crossover	2018	Blaster	2023
6	Custer	2027	R. Red	2032			Grapefruits are good
7	Dawson County	2024	N. Hicks	2029			Updated model, there were lots of errors on this model.
8	Fairview West	2024	N. Hicks	2029
MMO

Cell Formulas
Range	Formula
D2:D8	D2	=IF(ISBLANK(B2),"",B2+5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D30	Cell Value	>TODAY()	text	NO
D2:D30	Cell Value	between B2 and TODAY()+1460	text	NO

 

[etaf]

in column D - then its 2023
so its red as its less than today() year

=AND($D2<>"",$D2<YEAR(TODAY()))

Book1
	A	B	C	D	E
1	Substation	Date Stickered	Stickered By	Due Date
2	Bole	2026	G.Giant	2031
3	Circle	2024	N. Hicks	2029
4	Conrad	2024	N. Hicks	2029
5	Crossover	2018	Blaster	2023
6	Custer	2027	R. Red	2032
7	Dawson County	2024	N. Hicks	2029
Sheet2

Cell Formulas
Range	Formula
D2:D7	D2	=IF(ISBLANK(B2),"",B2+5)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D24	Expression	=AND($D2<>"",$D2<YEAR(TODAY()))	text	NO

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
D2:D1000 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($D2<>"",$D2<YEAR(TODAY()))

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK