Deadline alert

Demo man - Mar 25, 2015 at 12:06 PM
I would like to change the colour of a date cell (target date) to yellow when it is 3 days away from the target date and remain yellow only until the task is completed when it will return to no colour?

Can anyone help with this?