conditional formatting triggered by macro

  • Thread starter Thread starter jonah
  • Start date Start date
J

jonah

I have a column that I would like to compare to two
different columns. The only way I know to do that is with
A1=VLOOKUP(A1,$B:$B,1,FALSE)
which compares to one at a time.

What I would like to do is have a button that will run a
macro to do the above while a second button will run a
macro to do the same thing but with column C.
 
Hi
what is your expected result for this macro (or maybe this can be done
with worksheet functions)
 
My expected result was for the matches in the two compared
columns to highlight when the button was clicked.
As a VBA beginner, I was not sure how to do it, but I
found a place to look and found the formulas so I just
copied one to another macro and it works.
Thanks.
 
Back
Top