Conditional formatting is the most efficient way to find duplicate data in Excel. This tutorial shows you how to apply a built-in rule to highlight duplicates automatically.
עשו זאת עם בינה מלאכותיתבחר את הנתונים שלך
Highlight the range of cells or the entire column where you want to check for duplicates.
פתח את עיצוב מותנה
Go to the 'Home' tab, click 'Conditional Formatting', select 'Highlight Cells Rules', and then click 'Duplicate Values'.
Configure and apply
In the dialog box, choose your preferred formatting style from the dropdown menu and click 'OK'.
Yes, the built-in rule highlights every instance of a duplicate value, including the first one.