Is it possible to compare 2 cells in each row and highligt characters that are different?

[unhappyCamper]

I would like to do this with conditional formatting but don't know how. If not CF, perhaps VBA? The max len of both cells is 20 characters and I would want it do repeat for all rows in the worksheet.

Please see attached sample of what I would like to end up with. Thanks in advance for any suggestions.

1sample.JPG

[Special-K]

I think VBA is your only option.
Wait till a VBA expert comes along...

[unhappyCamper]

Thanks Special K. I was thinking that was probably the case. I hope there are some VBA experts around. I know there's probably a way to build a loop that goes through each character and sets format but that's a tad above my skill set without doing much trial and error.

[Akuini]

Thanks Special K. I was thinking that was probably the case. I hope there are some VBA experts around. I know there's probably a way to build a loop that goes through each character and sets format but that's a tad above my skill set without doing much trial and error.

The difference between the two column, is it only the last character?
If that is not the case, can you upload more samples?

[unhappyCamper]

I want to compare character by character for the two strings. there could be multiple differences in any location.

Capture.JPG

[Akuini]

Try this:

Please Login or Register  to view this content.

[unhappyCamper]

If I understand the code, this would only work if col 1 and 2 are the only columns. Correct? What if other columns existed and I only want to compare col A and say col G? Could I just change Mid(Cells(i,2) to Mid(Cells(i,7)?

[Akuini]

If I understand the code, this would only work if col 1 and 2 are the only columns. Correct? What if other columns existed and I only want to compare col A and say col G? Could I just change Mid(Cells(i,2) to Mid(Cells(i,7)?

Yes, you're right, just change Mid(Cells(i,2) to Mid(Cells(i,7)

[unhappyCamper]

Thanks for your help Akuini. Works like a charm!!

[Akuini]

Glad to help & thanks for replying.