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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving data from one column to another 5
compare two columns and pull out differences 1
Writing a macro to compare columns and return a value 1
Comparison of columns using Conditional Formatting 3
Count Based on Comparison with Two Fields 2
List Comparison 3
macro range 1
Excel Numbering rows by font color, but skipping blanks 1

Back
Top