Change cell to red when date in other cell is red
 

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

Change cell to red when date in other cell is red
 

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

Change cell to red when date in other cell is red
 

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

Change cell to red when date in other cell is red
 

If you provide some detail on the worksheet layout, and a couple of
sample rows, someone may be able to help with the formula.

cityfc wrote:
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





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