How to Highlight Duplicates on Google Sheets on PC or Mac

1. Open google sheet. 2. Select cells. 3. Click on format. 4. Click on conditional formatting. 5. In format rule click on custom formula. 6. Enter formula. 7. Click on done.