Related Post: Why Is Conditional Formatting Not Highlighting Duplicates Why Is Duplicate Conditional Formatting Not Working Conditional Formatting Not Finding Duplicates Why Is Conditional Formatting Highlighting Non Duplicates