Forum Discussion
Conditional formatting for lines which 2 staff members is busy in determined date and hours
If your system uses comma as decimal separator, you should use semicolon to separate the arguments of the function.
In Italian:
=O((CONTA.PIÙ.SE($A$2:$A$8;$A2;$B$2:$B$8;"<="&$C2;$C$2:$C$8;">="&$B2;$D$2:$D$8;$D2) + CONTA.PIÙ.SE($A$2:$A$8;$A2;$B$2:$B$8;"<="&$C2;$C$2:$C$8;">="&$B2;$D$2:$D$8;$F2))>1; (CONTA.PIÙ.SE($A$2:$A$8;$A2;$B$2:$B$8;"<="&$C2;$C$2:$C$8;">="&$B2;$F$2:$F$8;$D2) + CONTA.PIÙ.SE($A$2:$A$8;$A2;$B$2:$B$8;"<="&$C2;$C$2:$C$8;">="&$B2;$F$2:$F$8;$F2))>1)
See the attached demo workbook.
For example:
=OR((COUNTIFS($A$2:$A$8,$A2,$B$2:$B$8,"<="&$C2,$C$2:$C$8,">="&$B2,$D$2:$D$8,$D2) + COUNTIFS($A$2:$A$8,$A2,$B$2:$B$8,"<="&$C2,$C$2:$C$8,">="&$B2,$D$2:$D$8,$F2))>1, (COUNTIFS($A$2:$A$8,$A2,$B$2:$B$8,"<="&$C2,$C$2:$C$8,">="&$B2,$F$2:$F$8,$D2) + COUNTIFS($A$2:$A$8,$A2,$B$2:$B$8,"<="&$C2,$C$2:$C$8,">="&$B2,$F$2:$F$8,$F2))>1)
Hi HansVogelaar
Thank you for your answer but I think that this formula has an error because excel show me an error message when I try to execute it.
If your system uses comma as decimal separator, you should use semicolon to separate the arguments of the function.
In Italian:
=O((CONTA.PIÙ.SE($A$2:$A$8;$A2;$B$2:$B$8;"<="&$C2;$C$2:$C$8;">="&$B2;$D$2:$D$8;$D2) + CONTA.PIÙ.SE($A$2:$A$8;$A2;$B$2:$B$8;"<="&$C2;$C$2:$C$8;">="&$B2;$D$2:$D$8;$F2))>1; (CONTA.PIÙ.SE($A$2:$A$8;$A2;$B$2:$B$8;"<="&$C2;$C$2:$C$8;">="&$B2;$F$2:$F$8;$D2) + CONTA.PIÙ.SE($A$2:$A$8;$A2;$B$2:$B$8;"<="&$C2;$C$2:$C$8;">="&$B2;$F$2:$F$8;$F2))>1)
See the attached demo workbook.
- Thank you so much! Now it works
