Related Post: Excel Conditional Formatting Duplicates Not Blanks Excel Conditional Formatting Duplicates Ignore Blanks Excel Conditional Formatting Duplicates Not Working Excel Conditional Formatting Based On Another Cell Not Being Blank