How to highlight duplicates in Excel
Conventional equation =COUNTIF(data,A1)>1 Explanation Note: Excel contains many implicit "presets" for featuring values with restrictive arranging, this incorporates to feature copy esteems moreover. In any case, in the event that you need greater adaptability, you can feature copies with your own equation, as clarified here. If you need to feature cells that contain copies