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 file matching the same date and hours in another line, it fill my line or cell in red. In order to make the idea more clear please watch the following image:
I don't know how to get out of it.
Could someone help me?
Thank you in advance
=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.
=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.
- Thank you so much, it works! Amazing
