This tutorial requires no formulas or macros to create an alert on approaching due dates.

 

Simply open the spreadsheet and fill in the date due and tasks and the other related items as you want.
I am currently using a dummy sheet to show you.

4

How easily it can be done.
Now we want to color the cell red as reminder if the due date is closer and within a week.

3

Simply select the cells.

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

now click conditional formatting select the – A date occuring option

Now choose “This week” Option

2

And format the cell to be colored as “red”

1
Thats it

Now to add more ,,, if you want to create an Message for the color that generated than you have to follow this thread and this documentation

http://bit.ly/1nWejz5

http://bit.ly/1ttcqB6