Trouble creating reference formulas for dates and cell shading

Morning,

I could use some help figuring out how to do a thing with dates. YouTube videos and Microsoft Excel help/tips hasn't resulted in a solution. I think I'm close but could also be way off.

I'll try to articulate what I want and what I've done, and I'll add a screenshot.

• What I want:
  • Manually enter a date into D164 (aka 3/17/2026)
  • E164 to be two years after D164 AND color coded in three ways:
    • green from "D164 date" up to 10 months later (aka 3/17/2026 to 1/17/2028)
    • yellow starting at that 10 months date until two full years (aka 1/18/2028 to 3/18/2028)
    • and red thereafter (aka 3/19/2028 and on)
• What I have/does work:
  • E164 formula @ "=IF(D164="","",DATE(YEAR(D164)+2,MONTH(D164),DAY(D164)))"
  • E164 conditional formatting (CF) @ highlight cells with red/red if "not blank"
• What I've tried (and I know they're wrong but maybe close?): changing the E164 conditional formatting to the following
  • E164 CF @ "=D164=TODAY()+670" set to highlight green
  • E164 CF @ "=D164=TODAY()+671" set to highlight yellow
  • E164 CF @ "=D164=TODAY()+730" set to highlight red
• What I think I'm missing: do I need to set a cell with the current date for everything else to reference?

Edit to add have/does work: D164 conditional formatting @ "cell does not contain blank value" set to highlight green

Thanks!

https://preview.redd.it/8ls6dob2lupg1.png?width=1215&format=png&auto=webp&s=954962fcc6c68b9b890f16f7765d93abafdd08d5