Conditional Formatting of Dates

[das1959]

I need to change the background color of a cell based on the date. This what I am trying to do.

Cell E3 contains a date and is being compared to a date in cell O3.

- If E3 is less then O3, the background color needs to be white
- If E3 is greater than O3 but less then O3+7 days, the background color needs to be yellow
- If E3 is greater than O3+7 days, the background color needs to be red

I have been playing around with Conditional Formatting, but cannot get the formulas to change the background color correctly. The background is always red.

Can someone show me how to enter equations in Conditional Formatting?

[Special-K]

Select the cell you want to change

Conditional Formatting
New Rule
Use a formula to determine...
Assuming the background is already white then only 2 formulas are required

=(AND(E3 > O3,E3 < O3+7))
format as yelow

=(E3 > O3+7)
format as red

Use Format painter (paintbrush icon) to copy to other cells