How to highlight duplicates in Google Sheets

If you've added the same data more than once by mistake on a spreadsheet or you're simply looking to find duplicate data, Google Sheets lets you highlight them.