Peta Durose
New Member
- Joined
- Sep 27, 2022
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
I am really hoping someone can help, I feel like this is an easy one, but I just can't get it.
I have a workbook to manage my work load.
Sheet one is a summary of all my projects
Sheet two and beyond is separated by project and the work required with due dates.
In sheet 2, it has a list of tasks and dates they are due (F16:F22) - I have conditional formatting on these to highlight anything that is within the next 7 days.
In sheet 1, I want to have a reminder column - so if ANY column is highlighted in Sheet 2 F16:F22 it will highlight in one cell (I2).
Screenshots attached.
Thank you in advance!!
I have a workbook to manage my work load.
Sheet one is a summary of all my projects
Sheet two and beyond is separated by project and the work required with due dates.
In sheet 2, it has a list of tasks and dates they are due (F16:F22) - I have conditional formatting on these to highlight anything that is within the next 7 days.
In sheet 1, I want to have a reminder column - so if ANY column is highlighted in Sheet 2 F16:F22 it will highlight in one cell (I2).
Screenshots attached.
Thank you in advance!!