![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |