Deadline alert

[Closed]
Report
-
Hello,
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?