Conditional formatting for 30,60,90 a year from due date

Hello, please forgive my very basic excel knowledge. I looked through Google and YouTube and still couldn’t figured out.

I want to create a conditional formatting rule where it highlights 30,60,90 days prior to a due date.

Let’s say the date is 5 March 2026, I want to set a ‘reminder’ for a year from now. I want to set a reminder for 30 days from 5 March 2027, 60 days from 5 March 2027, and 90 days from 5 March 2027. And if it’s past 5 March 2027, then I want to format it to be red.

I tried googling it and everything I found show me how to create conditional formatting rules that is 30 days from today. Like = today()+30

But that is not what I want though. I want to know 30 days from the date year from the date I have In the cell.

Please help.