Compare two columns

  • Thread starter Thread starter Kaizen10
  • Start date Start date
K

Kaizen10

Hi,

I am a basic user and don't know advanced funtions.

Want to compare column A and Column B. Highlight the cell with some
color if any data is same in both the columns.

Any help is appreciated.
 
Depending on what I'm doing, I often have a column with the differences.
one column might be "ideal product margin", the other "actual product margin",
I use conditional formatting to either highlight the actual that is too low,
or the difference colum red for low, green for high, black for normal. not
real advanced, but super usefull.
 
Select all cells in column A
Menu Format>Conditional format
Select Formula is
Enter =COUNTIF(B:B;A1)>0
Select the format you like
Click OK

HTH
 
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

Excel Comparing two columns 1
VBA Excel partial cell compare to another cell 0
comparing 2 columns 6
comparing two columns 2
compare two columns and pull out differences 1
counting blank cells within two columns 2
Compare two cells in two different files and return answer 6
Comparing values in two columns 4

Back
Top