Duplicate Values Multiple Rows to be Highlited

[vanther]

Hello Everyone can some one help me about this, on how to highlight in one rows and 3 column if there is a duplicate.. i have attached here as an example....NameMatch.xlsx

[Moo the Dog]

Easy way:

In E2, put this formula: =A2&B2&C2

Fill that down to the end of your list.

Select cells A2:C15, then using a formula for Conditional Formatting, try this: =COUNTIF($E$2:$E$15,$E2)>1

- Moo

[MarvinP]

Hi vanther,

If you select the range and then do a conditional format on it asking for duplicates it will do what you want. see the attached.

[Moo the Dog]

I attached your original sheet, modified with the Conditional Formatting applied...

- Moo

[vanther]

Wow that's quick... thank you very much for quick reply....

Moo the Dog

you're great

and everyone/...