How to highlight duplicates in excel

Hello, My Dear Friends, !! In this video, I will show you How to highlight duplicates in Excel. Watch the video till the end Thanks.

Step 1: Select the data you want to highlight as duplicates.

Step 2: Click on the Home tab, then on the Conditional Formatting dropdown list.

Step 3: Select Highlight Cells Rules.

Step 4: Select the Duplicate Values option.

Step 5: Select your preferred formatting from the options provided, then click OK.

Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel.

#initial #solution #highlight #duplicates #in #excel