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

Our take

Creating a conditional formatting rule in Excel to highlight dates 30, 60, and 90 days prior to a specific due date can significantly enhance your productivity. To set this up, you’ll need to establish rules based on the target date, such as March 5, 2026, and then create conditions for reminders starting from March 5, 2027. This guide will walk you through the steps to format these reminders effectively, ensuring that any overdue dates are clearly marked in red.

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.

submitted by /u/Ashe225
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#google sheets#conditional formatting#due date#reminder#30 days#60 days#90 days#highlight#Excel#formatting rule#365 days#past date#date calculation#5 March 2026