How to Compare two columns based on Partial match

[abi007]

I need help on how to compare data in two col based on partial match so I want to compare then match with the right most characters so may be first 10 characters from the right or first 5 characters from the right then match with the same in col B and if they match identify them some how either color etc.

Keep in mind Col A and Col B are not in the same order or anything so for each cell in col A a search of the entire col B needs to be done for a match.

Any help?