compare values in two cells, highlight when there is no match.

I have a simple macro problem. I have two cells with values that are strings.

I would like to know of a macro that can compare each two cells(start from E2 and compare with E3)to see if the values are NOT equal.
If they are equal, do nothing and if they are NOT, highlight the value.

example:
compare E2&E3, E4,E5,E6,E7,.... if for example E2&E3, E4,E5,E6,E7,.... each has same string, do nothing, but if they were not the same highlight it with red.

this code checks two cells and highlights one cell when there is duplicate, I like the opposit one, but dont know what to change!

Please Login or Register  to view this content.

Thanks for your help.

Please Login or Register  to view this content.

Originally Posted by Fotis1991

Please Login or Register  to view this content.

Thanks. but It just worked for E2&E3 and not for other cells.

....Thanks. but It just worked for E2&E3 and not for other cells.

No this is not correct. I just change the equal sign(=) to <>. Nothing else..

You are welcome.

...I thought by <> which you mentioned the problem can be solved. but seems not.

The problem that you described to us in your first post is solved using this. If you want something else then i believe that you must describe your request better or even better to upload a sample workbook.

Good luck.

In your example, E6 & E9 are highlighted. Which is the correct result and why?

Ok. As in the example sheet everything is as you describe in your latest post(#10) and as for you the result is not good, i give up! This does no sense for me. Maybe someone else could understand better than me and will able to helps you. Good luck!

Originally Posted by Fotis1991

Ok. As in the example sheet everything is as you describe in your latest post(#10) and as for you the result is not good, i give up! This does no sense for me. Maybe someone else could understand better than me and will able to helps you. Good luck!

@Fotis1991, what I think he wants is to compare the values on adjacent rows, so the value on row 2 with the value on row 3, and then 4 with 5 and so on.

The trick will be when it finds a mismatch as happens with row 6, which is why it is highlighted. It then should highlight and IGNORE row 6, and start the comparison process again by looking at rows 7 and 8, which are fine, hence no highlight.

Then row 9 is different from row 10, so row 9 is highlighted, skipped and the comparison restarts by comparing row 10 with 11.

This would produce that result

Please Login or Register  to view this content.

It's true that VBA is not my best , BUT in this case really i was not able to understand the expected result.

I am glad that you found your solution.

@Olaf.Braxhoofden

Thanks for the explanation. Well done!