In our case, we select ‘Light Red Fill with Dark Red Text’.Ĭlick on OK and you shall see that the duplicate names have been highlighted in red color. You shall see a duplicate values dialog box, wherein you can select your formatting option. Select the first option ‘Highlight Cells Rules’ and the sub-option as ‘Duplicate Values.’ When you click on the dropdown of conditional formatting, you shall receive various options. Alternatively, you can also use shortcut key: Alt + H + L. So first we shall select the Name column (A1:A15).Ĭlick on the conditional formatting option available at the right hand side of the home tab. In our example below, we want to find if any name has been repeated. You have successfully removed the duplicatesįor finding the duplicates we shall be using the conditional formatting function.You have successfully found the duplicates.Finding and Removing Duplicates in 8 Steps
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |