If you need to highlight duplicates in Google Sheets, you can use conditional formatting. Here's how.
You can lock cells or entire sheets in a Google Sheets spreadsheet to prevent editing. Here's how.