How to Find Duplicate Data in Excel using Data Validation and Conditional Formatting - Part 1

How to Find Duplicate Data in Excel using Data Validation & Conditional Formatting Way 1: Click Home - Conditional Formatting - Highlight Cells Rules - Duplicate Values. Way 2: Select the data - Data Validation - Apply custom formula into Custom option from the drop down to restrict duplicate entries Free Downloads: https://prabastech.com/free-downloads/ Excel Training in Tamil: https://www.youtube.com/watch?v=GMYeU-Hiuzo&list=PLXqX9fbIzJMZI-JIQnOQSp1kEPRdvEtIY -~-~~-~~~-~~-~- Please watch: "Play with Duplicate Data in Excel - Part 2 - Highlight, Remove, Trigger" https://www.youtube.com/watch?v=POsx7UGSP58 -~-~~-~~~-~~-~-