•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to highlight the cell when it's showing a date that's 1 month after today's date?
Our take
To highlight cells in column D that display a date one month after today, you can use conditional formatting effectively. First, ensure your dates are correctly formatted as dates, even if they appear as "Renewal ddmmmyy." For the initial highlight, use the formula `=AND(D2=TODAY()+30, D2<>"")` to turn the cell yellow. For the future color change once the date becomes today, you can modify the formula to `=AND(TODAY()=D2, D2<>"")`. This approach keeps your data dynamic and visually
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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 date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Conditional formatting for future datesPlease let me know if there's a better place for this question, I'm new to reddit. I have to keep track of dozens of people various certifications. The date inputted is the date they got it. I want to format it so it's green unless: In 9 months from today's date it turns yellow In 11 months from todays date it turns red I'd like to use the edate feature to account for monthly shifts, but the only formatting I've done were on actual expiration dates (using the greater than/less than feature), not future ones. Any suggestions or videos that would help? submitted by /u/Altriss1 [link] [comments]
- Trouble creating reference formulas for dates and cell shadingMorning, 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 submitted by /u/antagog [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#conditional formatting#highlighted#date#1 month#today's date#column D#Renewal ddmmmyy#filtered#conditions#color#FUTURE COLOR#rule#cell