Number Comparison

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I am trying to write a macro that compares two columns of
numbers on a spreadsheet and colors the cells of all the
numbers that match. After the macro is run I would like
to be able to see all numbers that are different in each
column. Can anyone figure out how or if EXCEL can perform
this function?
 
Why use a macro. I would just use conditional
formating. This will do the highlighting for you.

Conditional format-->=if(A1=B1,True,False)
Do the same thing in both columns.
 
Back
Top