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