find duplicates in rows

[cesarsin]

how can i find duplicates by rows not column

[XOR LX]

Hi and welcome to the forum.

Perhaps you could start by providing a little more information?

Regards

[cesarsin]

thank you for your reply
i have a set of data with duplicate values in each row
i want to find the duplicates and highlight them by row similar to the one available in excel for column

[XOR LX]

But Conditional Formatting for duplicates will work for a row as well as for a column.

Highlight your range then:

Home/Conditional Formatting/Highlight Cells Rules/Duplicate Values

Regards

[cesarsin]

i know it will work but at one row at a time
i have thousands of rows that i want to apply it on

[XOR LX]

In that case, after first highlighting your range, e.g. A1:J12, and, importantly, making sure that the active cell in the worksheet is A1 when you do so, go to:

Home/Conditional Formatting/Use a formula to determine which cells to format

and enter this in the Format values where this formula is true: box:

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

Regards

[cesarsin]

thank you
it works perfectly

[XOR LX]

You're welcome.

Regards