I'm trying to produce a spreadsheet whereby a date is entered when an
activity should be completed by. I want it to produce the following outcomes:

1) when activity is selected and cell is orange and shows date to be
completed by
2) when completed before due date, date is entered and cell turns green
3) when due date has passed cell turns red

I can't seem to fit all this into conditional formatting and don't know how
to carry all this out using IF.

Help!!