Related Post: Excel Conditional Formatting Duplicate Values Not Working Excel Conditional Formatting Duplicates Not Working Excel Conditional Formatting Duplicate Values Different Colors