Related Post: How To Avoid Duplicate Values Using Conditional Formatting Why Conditional Formatting For Duplicates Not Working