In this Excel video tutorial, we gonna see how to Highlight Duplicates in Google Sheets with 2 criteria 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

In this example we will use more than one condition, that is, if the values in a column are repeated, they do not necessarily need to be painted, but I need to check in another column to see if the information is also repeated there, so in this example I will use two criteria to find out if Should I highlight repeated values or not. You can use three four five or many more criteria no matter the quantity

To help us, we will use the Countif function or countif formula to count the number of times a value appears and we will also use a help column to gather the information.

Highlight Duplicates in Google Sheets: https://youtu.be/I4MFMiOlhmg

#JopaExcel #Dashboard #Excel