compare 2 columns in excel and find differences

Don't need any special skills, save two hours every day!
Lets say, you have two lists of students names in Column A and Column B of your worksheet, and some of them are khutbat e faqeer book both in the two columns, but now, you just want to compare these two columns and list the different names from them.
Select the Conditional Formatting button under the Home tab.Compare two columns and list differences with formulas.Click on the Format button and specify the format you want to set.Artem must be an Excel Yoda.So this is how you can easily see which values are duplicate in different columns in Excel.If you are not interested office 2010 professional plus trial in the formulas, here, I can recommend you a useful tool.Select the Conditional Formatting button on the Home tab.Say you want to find those in col.The conditional formatting rule then will be applied to all values of the column and should look like this.

You can also sort both columns individually, then select both, Goto Special, select Row Differences.Kutools for Excel, with its, select Same Different Cells utility, you can quickly find, shade or select the duplicates or unique values from two ranges.B2:B14 indicates another column that you want to be compared with) and then press.Compare two columns and list differences with Kutools for Excel.Select the New Rule option from the Conditional Formatting button drop-down list.The result is that it highlights in both lists the values that ARE the same.Demonstration of how repeated values are highlighted.