You can delete the formulas in the cells selfcloathing, I only put them there to test the formula. the conditional formatting is only dependent on the header (row 4) and the days off (columns K & L).