Do You Want Your Google Spreadsheet to Get Your Attention When Due Dates Are Near?

Here is an example of how to get a spreadsheet cell to turn RED when a due date is approaching.  For this example, my spreadsheet will have red cells when the date is 7 days prior to today or today.  All other dates will be white.

Today's date is : January 28, 2013.

1.  Open or create Google spreadsheet.  If you need help doing this, contact me and I will come help!

2.  Hover the mouse over the desired date column to expose the down-arrow, then click the arrow for the pull-down menu.  (see below)

3.  Click on the Conditional Formatting option as shown just above to bring up the dialog box below.

4.  Change Text contains to Date is.  The box will change to add another option.

5.  Leave the second box on today.

6.  Click the box after the Background: option and choose the RED square.

7.  Click the link for +Add another rule.

8.  Change Text contains to Date is after.  

9.  In the next box, change today to in the past week.

10.  Click the box after the Background: option and choose the RED square.

11.  Click on the Save Rules button.

Note:

• Date is BEFORE in the past week shows dates which happened more than 7 days ago.
• Date is in the past week shows dates which are 7 days prior to today

END