Highlight consecutive duplicates in Excel with one conditional formatting formula, then flag back-to-back weekly offs in an attendance sheet. Free practice workbook.