Highlight any dates that exceed a target date

Hello,

Wonder if someone can help me, I have a sheet that i want to calculate and highlight if one date is beyond another then highlight it red IF its in scope.

Rought Cell format...
1A Name
1B In scope - either a 1 (in scope) or 0 (Out of scope) or C (for complete)
1C Target Date
1D DR date
1E Calculation - on target (more than 7 days before DR date) Green, at risk (less than 7 days before dr date)Amber, Miss Target (after DR data) Red.

To be in scope Cell 1B has to be a 1 and then calculate the below.
If out of scope Cell 1B should be "0" and it should just display n/a
If "C" in Cell 1B it should just display Complete


For in scope this additional rule needs to be added.

eg.
DR date is 04/10/2017
Target delivery date is 03/10/2017

I want the cell with the calculation to turn red and display the detail "Target Miss"

If however target is less than 7 days I would like it to turn Amber and display "Possible Risk"

eg.

DR date is 04/10/2017
Target delivery date is 06/10/2017

If however the Target date is over 7days before the DR date I would like it to turn green & show "on Target"

eg.
DR date is 04/10/2017
Target delivery date is 27/09/2017

Any ideas?

Thanks in advance if anyone can help

Regards,

Lee