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): RedI 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.
Date Formatting for Deadlines
google spreadsheets;conditional formatting