Select the cells in Column A that you want to highlight the cells where the values exit in Column C as well.Ģ. In Excel, we can apply the Conditional Formatting feature to highlight the same values when found in another column, please do with following steps:ġ. Highlight cells if duplicate in another column with Kutools for Excel Highlight cells if duplicate in another column with Conditional Formatting
And this article, I will introduce some methods to deal with this task in Excel. How to compare two columns and highlight when found in another column?įor example, I have a worksheet with List A and List B s which have some same values both in these two lists, now, I would like to compare these two columns and then highlight the values both in the two lists from the List A to get the following result.
