How to color duplicates from two columns in excel #exceltips

You can use conditional formatting in Excel to highlight duplicate values between two columns. Here are the steps:

Select the two columns that you want to compare for duplicates.

Click on the "Home" tab in the Excel ribbon.

Click on the "Conditional Formatting" button in the "Styles" section.

Choose "Highlight Cells Rules" and then "Duplicate Values" from the drop-down menu.

In the "Duplicate Values" dialog box, select "Duplicate" in the "Values" section.

In the "Format" section, choose the formatting you want to apply to the duplicate values. For example, you could choose to highlight them in red.

Click "OK" to close the dialog box and apply the conditional formatting to the selected cells.

Now, any duplicates between the two columns will be highlighted according to the formatting you chose.

how to find duplicates in excel,find duplicates in excel,highlight duplicates in excel,colour duplicate values in excel,how to compare two columns in excel,how to compare two columns in excel using vlookup,microsoft excel,how to remove duplicates in excel,excel,how to highlight duplicates in excel,excel highlight duplicate values in different colors,remove duplicates in excel,compare two columns in excel,compare two lists in excel for matches

[jamilhfl]

Thank you very much your video is very supportive. It help me. Excellent job 👍