Identify overlaps in employees and days

Three step process:
1. Populate range R3:W14 (jobs) using: =COUNTIFS($P$3:$P$38,$P3,$Q$3:$Q$38,R$2)
2. Populate range Y3:AC14 (days) using: =SUMPRODUCT((B$3:B$7=$R$2:$W$2)*($R3:$W3))>1
3. Conditionally format B3:F7 using: =COUNTIFS(Y$3:Y$14,TRUE)
Let us know if you have any questions.