hi Akbar,
1) =IF(AND(IF(OR(book1!$C9="Driver",book1!$C9="Supervisor"),D9="")),1,"") the formula in Column "Q" , will check for the name "Driver"&"Supervisor" in the column D , and if the D9 is ="" and results you value 1,
2) The second part is the condition which i have used in conditional format if the the cell value in Column Q is 1 then color the cell or no change

Please check the Column Q and u will get a idea
Sorry for the late reply .

Punnam