To compare the two columns in Excel we should use Conditional formatting option in Microsoft Excel 2010 and 2013.
Conditional formatting is used to highlight important information on a spreadsheet. But sometimes the inbuilt formatting rules do not go quite far enough, adding your own formula for conditional formatting rules you can do things the underlying rules to help power promotes. This option is available in “Home Tab” in the group of styles.
To use the “Conditional Formatting” with IF statement, we put the IF condition in data then we will define the conditional formatting.
Let’s take an example and understand how we can compare two data through Conditional Formatting.
For Example: We have 2 customer’s lists in the range A2:B15. Column A contains the customer list for the year 2010 and Column B contains the customer list for the year 2013.
To compare the both lists follow below mentioned Steps:-
Again drop down menu will appear, click on Duplicate Values.
This is the way if you are comparing two columns then you can highlight the cells with the colors in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.