Related Post: Conditional Formatting Can Be Used To Highlight Duplicate Values Which Conditional Formatting Feature Can Be Used To Identify Duplicate Values On A Worksheet Can You Use Conditional Formatting To Highlight Duplicate Values In A Range