Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract name when a date in another cell gets near | Excel Worksheet Functions | |||
How to change cell colour, X no days from inserted date in Excel? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
How do I change the value in cell based on a future date | Excel Discussion (Misc queries) |