I have attached a file to this post to help explain my problem.
In Column A I have 5 tasks and in columns B and C I have start and end dates for those tasks.
In Columns D through K I have a schedule matrix.
I'd like Excel to color in the cells under the date range for each Task.
I've manually colored in cells D2 and E2 to show how I'd like the conditional formatting to look like.
Can anyone please help me set up the function and the conditional formatting for this?
Thank you.
Bookmarks