CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulags-conditional-formatting
Killercamin
Killercamin

Reputation: 125

How to highlight an entire row using conditional formatting. With duplicates being tested

I am looking for a formula that highlights duplicate sequences but at the same time highlights the entire row. I am using this formula for the duplicates right now 

=COUNTIF($A$1:$A$24241, INDIRECT(ADDRESS(ROW(), COLUMN(), 4))) > 1

The way my data is presented goes something like column: A,B,C,D,E with around 25000 rows. What I want to do is highlight the duplicates but at the same time highlight the entire row of that duplicate.

Example of row

Example: 

45| 120| 20|15

45| 100|  5|10

Now here the 45 are duplicates and I want to eliminate the entire first row. Even though the other values are different they mean nothing so they must be deleted.

Any help would be appreciated.

Upvotes: 1

Views: 133

Answers (1)

player0
player0

Reputation: 1

try like this:

=COUNTIF($A1:$A, $A1)>1

0

for 2nd+ occurance you can do:

=COUNTIFS($A$1:$A1, $A1)>1

0

Upvotes: 1

Related Questions