Compare two columns and highlight difference

It looks like you are comparing column B and column E, not row 2 and row 5.

"Function is basicly compare row 2 with row 5 and when there is a difference highlight cell." That description does not seem to match what this code does. The code looks at each value in column B to see if a value in column E can be found anywhere in the column B value; it will consider a partial match to be a match (that is, if E has "ABC" and B has "XABCX" it will be considered a match). Do you really want partial matches? For any non-matches it highlights column B in one color, and if it finds a match it highlights column B in a different color and then stops looking for matches for that row of column B. The code inefficiently repeats the formatting for non-matches until it finds a match.

Then it repeats this method looking for matches from column E.

Can you provide sample data for this so we can run the code? The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Is there a reason you want to use VBA to permanently format these cells rather than using Conditional Formatting to do the same thing? This code is a little more efficient but I think CF would be much faster.

Please Login or Register  to view this content.

Here is your attachment with conditional formatting. For column B the rule is

Formula:

Please Login or Register  to view this content.

A similar rule is used for column E.

This requires an exact match, which is probably what you actually intended. You haven't answered my question about partial matches.

This is lightning fast compared to a macro.