Match duplicate value in same row

**TestMailinator** · 03-25-2015, 02:53 AM

Hi Experts,

Excel 2010

I want to match duplicate value in same row.

explanation :

FX, I have two column A and B, A have codes and B have IDs I want to find out duplicate between column A (codes) and B (IDs), for this I have done conditional formatting > highlights cells rules > duplicate values > this solved my half problem because A duplicate highlighted value for example 123 highlighted in column A in row 3 and same value highlighted in column B in row 8 I want these highlighted duplicate value in same row.
I am not good at to explanation the thing so please see screen shot for further

best regards

**JazzKult** · 03-25-2015, 04:10 AM

Hey. You can do the following: select cell A2 -> conditional formatting -> new rule -> use formula to determine which cells to format:

Please Login or Register  to view this content.

Then use the format painter to extend this to the rest of the data

**skywriter** · 03-25-2015, 04:33 AM

Originally Posted by JazzKult

Hey. You can do the following: select cell A2 -> conditional formatting -> new rule -> use formula to determine which cells to format:

Please Login or Register  to view this content.

Then use the format painter to extend this to the rest of the data

I don't think that's what he wants. I think he wants the duplicate values themselves to be next to the appropriate same value in column A. If you look at his picture on the right there's a note and it seems to indicate that, or maybe I'm misreading it.

**shukla.ankur281190** · 03-25-2015, 05:16 AM

can you share you file once ???

**TestMailinator** · 03-25-2015, 08:56 AM

Originally Posted by shukla.ankur281190

can you share you file once ???

I have attached my original file. you see column A (codes) and column B (IDs). I want to check column A (codes) and column B (IDs) duplicate when I do conditional formatting > highlights cells rules > duplicate values >It show duplicate with light red coloured, Its fine but I need to show same duplicate in same row. As I mentioned image in my first question.
any expert can help me?

regards'