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.

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.