Conditional Formatting - Date Deadlines

[adamgwsmith]

Hi,

I really hope someone could help me with a few date formulae.

I need to format date cells to show the following deadlines:

WIthin 30 days (or in the past) - red cells
Between 30 - 90 days - yellow cells
Over 90 days away - green cells

It's mainly the correct formulae I need as I can manage the colour conditional formatting. However, in attempts made so far, some cells seem to excluded.

Any help would be greatly appreciated.

Thank you.

[NBVC]

Select cells and go to Format|Conditional Formatting

Set:

Cell Value is >> Less than or Equal to > =Today()+30

Click Format and choose Red from Pattern tab

Click Ok

Click Add

Cell Value is >> Between =Today()+31 and =Today()+90

Select Yellow and repeat as above with

Cell Value is >> Greater than >> =Today()+90