•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?
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]
Want to read more?
Check out the full article on the original site
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