Highlight Duplicates In Google Sheets (Row or Column) Using Conditional Formatting

In this video I demonstrate how to highlight duplicates in Google Sheets. This type of conditional formatting requires a formula. The functions used in this video are COUNTIF, MATCH and ARRAYFORMULA.

Table of Contents:

00:00 - Introduction
00:13 - Highlight duplicates in a single column
03:06 - Highlight duplicates but ignore first occurrence
05:08 - Highlight duplicates across multiple rows & columns - 2D range
06:17 - Highlight duplicates across separate columns to find matches and differences
08:05 - Highlight duplicates if entire record or row matches
------------------------

[bobybrahmam]

How to highlight duplicates side by side in a row, and apply that formula to all

[skazisrb]

Hello, I have problem with my formula which is "=COUNTIF(ARRAYFORMULA($B$2:$B$2572&$C$2:$C$2572&$D$2:$D$2572), B2&C2&D2"
The formula says "ERROR", everything seems okay but B2 at the end wont link with the b2 column, i mean everything other is highlighted when i click on it but only the last one "B2" is not highlighted when I click, so I think there is the problem. but why? Everything other seems okay, I checked everything 5 times to make sure every, ( ) & is here. Thanks!

[ASMRAFIQULISLAM]

Great! 100% perfect. Thank you so much.