To highlight duplicates in Google Sheets, select the column cells you want to check for duplicates. Then click on 'Format' from the top menu and select 'Conditional Formatting'. Under 'Format Rules', select 'Custom Formula is' and enter the formula as =COUNTIF($B$1:$B$10, B1)>1 (Here replace the cell address according to your required range) Connect your apps in 1 click with Integrately