• use nested iif conditions like below

    IIF(Job_Type.value="install" and completion.value<72,"red",iif(Job_Type.value="service" and completion.value<100,"red"),"green")