u/Ashe225

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.

Hello, I am looking to get a car and I came upon this 2013 FJ Cruiser with 180k miles for $18k. 3 previous owner with a clean title.
I heard that with high mileage car, I should replace the timing belt and transmission.

I just want to know if it is worth it to spend $18k (I want to pay cash) on a 180k car (and possibly more due to replacement of parts).
Thank you