Thread: Conditional Formatting - Date Deadlines

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.

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