View Full Version : Help to Modify An macros to compare

05-12-2008, 01:31 AM
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.

Bob Phillips
05-12-2008, 01:40 AM

05-12-2008, 05:07 AM
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
05-12-2008, 05:41 AM
See http://www.rondebruin.nl/easyfilter.htm