In this Excel video tutorial, we gonna see how to Highlight Duplicates in Google Sheets with Conditional Formatting and using the formula CountIF or countif function.

To highlight repeated values in Google Spreadsheets we can use conditional formatting and this way we will also have task automation or process automation every time a new repeated value is entered it will be highlighted with the selected color green red yellow etc.

This way we have a visual alert that shows us every time that some information has been used more than once and is being repeated in the Google Sheets spreadsheet

you can also use more than one criteria to highlight repeated values in Google spreadsheets you can use conditional formatting with multiple conditions

Highlight Duplicates using 2 Criteria: https://youtu.be/iEbwt6OkDQg

#JopaExcel #Dashboard #Excel