Newbeetle - Your below works great - one more thing - how do I add a third
condition which leaves the Due Date cell with no color if there is no date in
the cell.

I'm trying to prevent having to add the conditions each time a new item is
created in the list.

Thanks for your assistance. - Pete

"Newbeetle" wrote:

You can do this in conditional formatting found on the format menu.

First thing though I would do in a cell thats not being used is type

=today()

This will then shows todays date, so say this is cell "A1"

Say Cell "B2" has the due date, and Cell "C2" has the completed date.

ok say you need cell b2 to change colour, select this cell, go format,
conditional format.


This is condition one, on the drop down menu select "Formula Is"

Then type in the following

=IF(AND(B2<$A$1,C2=""),TRUE)

Then click format button, click pattens and change the sample colour to red,
then ok.

Click the add button, your now see condition 2, again

This is condition two, on the drop down menu select "Formula Is"

Then type in the following

=IF(AND(OR(B2=$A$1,B2<=$A$1+7),C2=""),TRUE)

Then click format button, click pattens and change the sample colour to
yellow, then ok.

Then ok button.


Should now work as required.
--
This post was created using recycled electrons!


"Pete Sperling" wrote:

One Cell contains a Due Date, and a second cell contains a Completed Date.
1. I would like to have the background of the Due Date cell to change to
yellow only when the date in this cell is within one week of todays date and
the Completed Date cell is still null, otherwise the background remains white
or transparent.
2. I would like to have the background of the Due Date Cell to change to
red only when the date in this cell is older than todays date and the
Completed Date cell is null.

Any help greatly appreciated - Pete