Sorry for the long title. This one is driving me batty. I have looked through Google for an answer, and the answers I found work if the data is arranged in the way the examples are written for, but for how my data is arranged it does not work.
Sheet explanation: the sheet is a n ever expanding work list where teams can be assigned to the task. Each column is a new task. Row 2 in the column has the start date, row 3 has the end date, and rows 5 through 11 have a drop down list of team members to assign to the task. The first task is going to be in column B, the next task in column C, so on and so forth.
WWhat I am looking to do is either prevent the user from assigning a team member to multiple tasks if the days for any of those tasks overlap, or at least have conditional formatting that highlights every instance of that member if they are assigned in an overlapping timeframe.
TThe examples I have seen work if the name is in one column, the start date in the next, and the end date in the third, and all the data already exists, but as mine is arranged via rows and I want to compare those to the next column, and my list is dynamic in that it will continually grow, I am having a hard time figuring out how to make it work for me. Any help would be greatly appreciated!
HHere is an example of what I am looking for/talking about Highlight records based on overlapping date ranges and a condition
Sheet explanation: the sheet is a n ever expanding work list where teams can be assigned to the task. Each column is a new task. Row 2 in the column has the start date, row 3 has the end date, and rows 5 through 11 have a drop down list of team members to assign to the task. The first task is going to be in column B, the next task in column C, so on and so forth.
WWhat I am looking to do is either prevent the user from assigning a team member to multiple tasks if the days for any of those tasks overlap, or at least have conditional formatting that highlights every instance of that member if they are assigned in an overlapping timeframe.
TThe examples I have seen work if the name is in one column, the start date in the next, and the end date in the third, and all the data already exists, but as mine is arranged via rows and I want to compare those to the next column, and my list is dynamic in that it will continually grow, I am having a hard time figuring out how to make it work for me. Any help would be greatly appreciated!
HHere is an example of what I am looking for/talking about Highlight records based on overlapping date ranges and a condition