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