Brendan, you'll need to specify 2 conditional format conditions he
1 use this formula:
=A1<=TODAY()
and choose the pattern red
2 use this formula:
=(A1-TODAY())<7
and choose the pattern yellow

Post back if I misinterpreted something wrong
--
Charles Chickering

"A good example is twice the value of good advice."


"Brendan" wrote:

I have tried numerous ways to make the below work but I cant figure it out.
All of the cells change to the color, instead of just one.

I have a due date in Column E (manually entered) and need the following:
From 7 days before the due date up to the actual due date, the cell needs to
be Yellow. Anything from the due date forward, needs to be red.