highlight duplicated rows

[lezawang]

Hi
Is there anyway to highlight duplicated row? I can highlight duplicated cells using Conditional formatting but that is not what I want. I want excel to highlight duplicated row only (rows which has identical values/cells). Thank you.

 

[Joe4]

I can highlight duplicated cells using Conditional formatting but that is not what I want.

You might be able to use Conditional Formatting for whole rows too.
How many columns need to be checked?

 

[braindiesel]

Would this work?
I added a helper column and used & to concatenate words and numbers..
then a simple countif takes care of it.

See image... https://ibb.co/caBBQ7

 

[lezawang]

Thanks for your reply. From A to M. Thank you once again

You might be able to use Conditional Formatting for whole rows too.
How many columns need to be checked?

 

[Joe4]

Thanks for your reply. From A to M.

With that many columns, I think I would look at using Brian's suggestion, instead of trying to program some monstrous formula in Conditional Formatting.
You can then do Conditional Formatting off of that built "helper" column.

Note: If you could use Microsoft Access, this would be a bit easier, as they actually have a built-in "Find Duplicates" Query Wizard to do it for you.
But I have the feeling that this may be part of a bigger Excel project...