![]() ![]() In Duplicate Values dialog box, select the Conditional Format that you want to apply for cells with duplicate values and click on OK.Īfter this, Cells with duplicate values will become highlighted, making it easy for you to change or delete the Cells containing duplicate data. After selecting data, make sure you are on the Home tab > click on Conditional Formatting > Highlight Cells Rules and select Duplicate Values option.Ĥ. Using Mouse, select the entire section of data that you want to check for duplicate values.ģ. Open the Excel File containing data that you want to check for duplicates.Ģ. So let us go ahead and take a look at the steps to find duplicates in Excel using Conditional Formatting. Once duplicate values are highlighted, it makes it easy to correct those values by deleting or modifying the duplicate values as required.
0 Comments
Leave a Reply. |