I am trying to set the following to have conditional formatting:

Current date < Current date+14 days = Green shade
Current date+15<Currentdate+30=Yellow shade
<=Current date=Red shade

I am having trouble with the Between formulas.
I have tried something like:
Cell value is BETWEEN: [NOW()] and [NOW()+14] Green shade
Cell value is BETWEEN: [NOW()+15] and [NOW()+30] Yellow shade
Cell value is GREATER THAN: [NOW()+31] Red shade

But i get no CF?

The values ARE a calculated DATE value, Does this mean i should use the
FORMULA IS instead of the Cell is?

I then ONLY get Value is and Not the option of IS BETWEEN....


Any ideas
i am sure it is a simple formula sintax error i am doing wrong
Regards

Corey