Google-sheets – Google Sheets date conditional formatting

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.

There might be a better way, but try three conditional format rules on C1 in this order:

1. "Custom formula is"; Value: =IF(A1="Done",TRUE,FALSE): set background to White

2. "Date is after"; "exact date..."; Value: =NOW()+3: set background to Green

3. "Cell is not empty": set background to Red. This is the default if the cell is not "Done" and the date is not after three days from now.

You could also keep rule 1, and then have rule 2 being a Colour Scale. You might need to put an extra cell to convert NOW() into a day count, though: =NOW()-3 for example.