That works a treat thanks but 1 small problem i have other columns in the
database with due dates for the same name.
What i mean is if the first column has been filled with a date how do i get
it to look along the row under other columns for missing dates

sorry to be a pain

"Debra Dalgleish" wrote:

You can use conditional formatting to change the name cell colour. For
example, if Due dates are in column D and Completed Dates are in column E:

Select the cells with names
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the active row:

=AND($E2="",$D2-TODAY()<=7)

Click the Format button, and on the Patterns tab, choose the Red colour
Click OK, click OK

cityfc wrote:
Hope someone can help

What i have is column a/b has names in and other columns with dates. Now
under these dates i enter a date that a person completed assessment. so when
this date gets near to 7 days before its due the cell turns red if no date is
entered. What i want is the cell with name going red aswell

Hope someone can help


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html