Forum Discussion
Solved
Conditional formatting for lines which staff is busy in determined date and hours
Hi everyone, I have a file where are 4 columns "Date", "Start Time", "End time" and "Tutor". I would like to set a conditional formatting that when a "Tutor" is inserted two or more times in the fi...
=SUMPRODUCT(($D$2:$D$10=$D2)*($A$2:$A$10=$A2)*($B$2:$B$10<=$C2)*($C$2:$C$10>=$B2))>1Maybe with this rule for conditional formatting.
Now I have to face a new challenge. I have inserted the "Teacher" column and there is the possibility that a"Tutor" is even a "Teacher".
So now I need a conditional formatting that checks if Tutor and Teacher match in the same date and hours, like the following image:
Do you have a solution also for this?
I hope I was clear in the explanation.
Thank you very much.
Could you start a new discussion for this question? Thank you.