To find duplicate values in Google Sheets, follow the steps given below:
- Select the cells where you want to check for duplicates
- Click on the Format menu
- Choose Conditional format
- Select Custom formula is from the drop-down
- Enter the formula
- Choose the formatting style for the duplicate values
- Click Done to apply the conditional formatting