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.

	A	B	C
1	Date Approved	Review Date	Trial Expiry
2	06/04/2016 (manually entered date)	A2+728	A2+90

<tbody>
</tbody>

 

[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