Conditional Formatting 'greater than/less than' for cell containing variable date based on a formula

[Bekker]

Please please please someone help!
I have a spreadsheet as below. A2 - 'Date Approved' is manually entered, B2 - 'Review Date' and C2 - 'Trial Expiry' are automatically calculated based on the date entered in A2 - 'Date Approved'.
I need to conditionally format as follows:

B2 - Cell to turn green when B2 'Review Date' is less than or equal to A2+728
B2 - Cell to turn red when B2 'Review Date' is greater than or equal to A2+729
C2 - Cell to turn green when C2 'Trial Expiry' is less than or equal to A2+90
C2 - Cell to turn red when C2 'Trial Expiry' is greater than or equal to A2+91

I have tried so many combinations but I cannot for the life of me get it to work correctly.

Thank you in advance for any help you can offer.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Date Approved[/TD]
[TD="align: center"]Review Date[/TD]
[TD="align: center"]Trial Expiry[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]06/04/2016
(manually entered date)[/TD]
[TD="align: center"]A2+728[/TD]
[TD="align: center"]A2+90[/TD]
[/TR]
</tbody>[/TABLE]

 

[MarcelBeug]

It doesn't make much sense to me if e.g. B2 is calculated as A2+728 it will never be >=A2+729.
Anyhow you need a rule, based on a formula, for each situation, e.g. the first rule with formula: =B2<=A2+728