Search code examples
google-sheetsgoogle-sheets-formulags-conditional-formatting

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.

Solution

  • try like this:

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

    0

    for 2nd+ occurance you can do:

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

    0