delulytric
New Member
- Joined
- Mar 15, 2019
- Messages
- 4
Hi, I've the following (simplified) table below:
I know this question has been asked a few times, but when I tried implementing the code it wasn't smooth for me.
The actual table I'm trying to implement comes in the form of a PivotTable, with many different titles as the row header (1 title can have multiple students), and many students attending the course. But I figured that it could be simplified into a timetable clash check for any particular user.
In this case, I'd like the result to be highlighted in Red since both student A and student B have course clashes in between.
Any help would be appreciated. Thank you!
| Title | StartDate | EndDate | Student |
| A | 21/12/2020 9:00 | 23/12/2020 14:00 | A |
| B | 13/1/2021 9:00 | 14/1/2021 14:00 | B |
| C | 24/11/2020 9:00 | 27/11/2020 17:00 | A |
| D | 14/1/2021 9:00 | 16/1/2021 14:00 | B |
| E | 7/1/2021 9:00 | 8/1/2021 15:00 | A |
| F | 6/1/2021 9:00 | 7/1/2021 14:00 | A |
| G | 1/12/2020 9:00 | 3/12/2020 14:00 | B |
I know this question has been asked a few times, but when I tried implementing the code it wasn't smooth for me.
The actual table I'm trying to implement comes in the form of a PivotTable, with many different titles as the row header (1 title can have multiple students), and many students attending the course. But I figured that it could be simplified into a timetable clash check for any particular user.
In this case, I'd like the result to be highlighted in Red since both student A and student B have course clashes in between.
Any help would be appreciated. Thank you!
