Help to Modify An macros to compare

[teodormircea]

Hello EveryOne

I have a macros that compare columns , taht you choose and color the Match with a color. The problem with this code is that the columns must have the same size and the match value must be on same level.
So i would like some help to modify it in order to have differents size for the columns and to color all the match values in this 2 columns.
I join an file with an exemple and the code .Also is possible that both columns can have blanks cells.
Thanks

[Bob Phillips]

.

[teodormircea]

Thanks for this solution, the problem is that with conditional formatting i don't have a real color font for the cell, and when i'm applieng a filter doesn't work.That's way i prefer to improuve this macros.

[Bob Phillips]

See http://www.rondebruin.nl/easyfilter.htm