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.
=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.
Thank you so much, it works! Amazing