I have set up a Google spreadsheet for managing projects and due dates, and I need to apply the following formatting to a column of dates, but I'm not sure how:
- Dates more than 7 days from today: Black
- Dates less than or equal to 7 days from today: Green
- Dates before today (late projects): Red
I found someone having a similar issue, but this doesn't actually do what it needs to do. It turns dates that are only 1 week LATE orange. It does not change dates that are one week AWAY orange. So this isn't working... unless I'm missing something.