The first part is the conditional part, the second is the cell value if the condition is met and the third part is the cell value if the condition is not met. Figure how you want to compare the values in A1 to B1 – equal, greater, lesser etc.
Lets say you have the list values in A1 and B1. If you have two columns containing numerical values, you can use the If() function to find whether the value of one column is greater than the other, less, equal to or not equal to. Using IF function to differentiate between values of two lists Now Click the “Format” button and set the font, border and fill options to highlight the cells you want. Alternatively, if you want to format only duplicate values, select “Duplicate values”. First select “ Format only unique or duplicate values.“, then, choose “Format only unique”. For instance, say you want to highlight all the data that’s different in the both the columns. Depending upon your preference choose one of them. Click on “Highlight Cell Rules,” and then go straight to “More Rules” and click on it. In the Home tab, click “Conditional Formatting”. Select the two columns that you want to compare. How would you do it? Here’s one way you can use to compare two lists and identify the different or duplicate data. You want to compare them to find out whether they have some common data, or highlight the different data sets. Say you have two lists of data (List 1 and List2) in your excel worksheet. 
Use Conditional Formatting to Differentiate and Highlight Values Once you’re done, read on to learn about some of the most commonly used functions to compare and retrieve data in Excel. We assume you have a basic working knowledge of Excel.If not, we do recommend you try out this Excel course that’s been made really easy or alternatively this Excel crash course for beginners. In this article, we walk you through just how to do that. This widespread use is more often that not likely to lead to situations where you want to find the difference between certain tables, columns or entire spreadsheets. Excel is extremely versatile and this leads to it being the most popular spreadsheet software in the market today.
0 kommentar(er)
