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