If I put a date of 1-JAN-15 in cell B2 and want it to be Green, then 30 days later 30-JAN-15, I have not changed the date I want it to turn Orange, then if 45 days 14-FEB-15, the date still hasn't changed, I wanted to turn Red.

How do I accomplish this?

Day 1-29 = Green

Day 30-44 = Orange

Day 45+ = Red

Thank you for your time

Select the cell or cells with the dates.

Color them green (the default).

• On the Home tab of the ribbon, click Conditional Formatting > New Rule...
• Select 'Format only cells that contain'.
• Leave the first dropdown set to 'Cell Value'.
• Select 'less than or equal to' from the second dropdown.
• Enter the formula =TODAY()-30 in the box next to it.
• Click Format...
• Activate the Fill tab and select orange.
• Click OK, then OK again.

Repeat the above steps, but with =TODAY()-45 as formula, and red as fill color.

You can also have gradient colors:

• Select cell B2
• On the Home tab, click Conditional Formatting, then Color Scales, then Green-Yellow-Red-Scale
• On the Home tab, click Conditional Formatting again, then Manage Rules
• Click Edit Rule
• Under Minimum, choose Equation as Typ, =TODAY() as formula
• Under MidPoint, choose Equation as Typ, =TODAY()-30 as formula
• Under Maximum, choose Equation as Typ, =TODAY()-45 as formula
• Click Ok, Ok

Andreas.