Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
You can't do that without the use of Google Apps Script. – Jacob Jan Tuinstra Mar 27 '13 at 14:12

With New Google Sheets please try Custom formula is:

  1. =today()-a1>7 with Background red and Range: to suit
  2. =and(A1-today()>0,A1-today()<28) with Background green and same Range:
  3. =A1-today()>=28 with Background white and same Range:
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.