Hello! I have a spreadsheet with task assignments for my team. It is a table.

Column A is the name of the person assigned, header is Marketing Advisor.

Column B is the date they were assigned, column title is Assigned Date.

Column C is a formula of =[@[Assigned Date]]+7. Column title is Due Date.

Column D is the date it was completed, titled Completed Date

I would like to use conditional formatting to highlight the Due Date in red if it is past the due date and no completed date is entered. Is this something I can do? If so, can you please provide the formula?

I’ve redacted the names for privacy, but here is the spreadsheet. Thank you!

​Hello! I have a spreadsheet with task assignments for my team. It is a table.Column A is the name of the person assigned, header is Marketing Advisor.Column B is the date they were assigned, column title is Assigned Date.Column C is a formula of =[@[Assigned Date]]+7. Column title is Due Date.Column D is the date it was completed, titled Completed DateI would like to use conditional formatting to highlight the Due Date in red if it is past the due date and no completed date is entered. Is this something I can do? If so, can you please provide the formula?I’ve redacted the names for privacy, but here is the spreadsheet. Thank you!    Read More

​