Thank you Dave, So there's no way to apply the condition to the whole sheet to make the row grayed out automatically everytime an employee change status from Active to Quite/Resigned (which being selected from the drop list)?
How about macro of VPscript (which I'm not too familiar with them)?