View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey Corey is offline
external usenet poster
 
Posts: 276
Default Conditional Format based on date ranges

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