•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting for future dates
Please 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?
[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
#Excel alternatives
#conditional formatting
#future dates
#certifications
#green format
#yellow format
#red format
#track certifications
#date inputted
#edate feature
#formatting suggestions
#9 months
#11 months
#expiration dates
#future formatting