•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formating with dates
Our take
If you’re struggling to highlight dates in your spreadsheet based on specific time criteria, you're not alone. Many users find it challenging to implement conditional formatting that visually signals when dates fall within designated time frames. Imagine automatically filling cells with color to indicate if a report is overdue by 1-2 months, 3-5 months, or even 6+ months. In this guide, we’ll walk you through a straightforward approach to set up this functionality, empowering you to enhance your reporting efficiency and clarity.
I am trying to automatically highlight cells where the date in the cell falls within certain criteria.
Example: A report was received on Date "A". The due date is "B". I am trying to auto fill the cell with color if the date is 1-2 months past B, 3-5 Months past B, and 6+ months past B. For the life of me I cannot figure out how to do this.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional Formating to highlight different dates on a spreadsheet.Hi there, I need assistance with creating a formula to highlight dates that are 3 - 6 months hold and dates that are +6months from the date I open the spreadsheet. Example, this spreadsheet was created today, but if I were to open the spreadsheet on 3 weeks, the highlighted dates change according to that days dates if applicable to the rule. The data I'm trying to do this for is A1:J565. Row 1 are column titles if that makes a difference for the rule. The date colum is I. I appreciate any help I can get. submitted by /u/Salty-Departure7245 [link] [comments]
- Conditional formatting for datesHow would I achieve automatic colour changing dates with exceptions. For example I need to be able to put in any date for applications (so they don't exist yet.) and then after 30 days i need it to go orange and then from that 30 days another 7 days it goes red but if the completed column is checked i need the conditional formatting to be invalid as it wont be necessary for the colours to change. How do i achieve this? column - date application received (23/02/2026) turn orange at (23/03/2026) turn red at (30/03/2026) stays white or turns white is column competed has "D" submitted by /u/No-Sink-6054 [link] [comments]
- Conditional Formatting Issue Between DatesHello all, Fully admitting I am not the best at Excel so be nice please. I am using a spreadsheet in my job that I use to track dates for service users. I have a column for any time that a user has received a piece of paperwork. If it has been beyond 90 days then I have the conditional Formatting set to a green background. The formatting for this is cell value > less than > today() -90 The issue is when I'm trying to have a red background for any paperwork submitted within those 90 days. I had this already formatted with cell value > between > today > today() -90 This worked up until today. I put in a value for a few days ago and the background has turned white instead of red and I can't seem to fix it. Any help would be greatly appreciated. submitted by /u/SDEMPSEY90 [link] [comments]
- How to highlight the cell when it's showing a date that's 1 month after today's date?I'd like a cell to become highlighted when the date it's showing is 1 month after today's date. I'd also like it to stay highlighted YELLOW until that (1 month later date) becomes today's date, after which it becomes highlighted with another color. These cells are under 1 column D. And they're filtered as such: "Renewal "ddmmmyy So that the text displayed is Renewal ddmmmyy but the conditional formatting still reads it as date so that conditions will apply. Brave leo gave this conditional rule for the FUTURE COLOR let's call it: =AND(TODAY()>=D2-30, TODAY()<=D2, D2<>"") But that didn't work for some reason. Could someone help? highly appreciated. submitted by /u/notmuchery [link] [comments]
Tagged with
#Excel alternatives for data analysis#rows.com#financial modeling with spreadsheets#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Conditional Formatting#dates#highlight cells#Excel#criteria#due date#auto fill#color#months past#report received#timeframe#automated highlighting#thresholds#date calculation