1 min readfrom 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?

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

Want to read more?

Check out the full article on the original site

View original article