Google Sheets – Formatting Cells Based on Upcoming Date

Yes.

Use Conditional Formatting with three rules: (Format -> Conditional formatting)

1. "Date is before" "in the past week" -> red
2. "Date is after" in the past week" -> green
3. "Date is" "in the past week" -> orange

This will colour all dates more than a week away in green, all dates coming in the next week orange and the remainder of the dates in red. Empty cells will be left alone.

For Dates more than 7 days from today: Black I am assuming (i) more than 7 days in advance of today and (ii) black font is suitable – so no conditional formatting is necessary other than that applied elsewhere.

For Dates less than or equal to 7 days from today: Green I am again assuming in advance of and suggest select column, Format, Conditional formatting…, Custom formula is:

=and(A1<today()+7,A1>=today())  

with Background Colour: ticked and green chosen.

For Dates before today (late projects): Red select column, Format, Conditional formatting…, Custom formula is: as before and:

=and(A1<>"",A1<today())  

with Background Colour: ticked and red chosen.