you are wellcome.

conditional formatting with a formula to display the blank cells may help. you may apply different fill colors for different departments.

select the related range for a dept and then conditional format the range with, say, =ISBLANK(D3) formula.
use relative cell reference.