I work at a language school and I have a column giving the students expected arrival date.
I want to set conditional formatting to:
Highlight in red any date that is older than 1 week
Highlight in Green any date that is in the next 4 weeks in the future.
This will show students who haven't turned up & also those coming in the next 4 weeks.