Compare 2 columns in a worksheet.

  • Thread starter Thread starter Neeraja
  • Start date Start date
N

Neeraja

Hi,

I need to compare 2 columns in a worksheet and see if the
values are similar.
Eg:
A : B
X-001 X-001
X-024 X-024
x-090 X-089
X-334 X-334
X-323 X-323

The third row must be highlighted here because the value
is different in the 2 columns. Is there any Excel
function to compare 2 columns?
Can someone tell me how to do this.

Thanks,
Neeraja
 
Neeraja, here is one way =A1=B1 put this in C1 and copy down, will retrun
true if the cell are the same or false if the cells are different
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Select the cells that might need to be highlighted. Then select
Format->Conditional Formating. Change "Cell value is" to "Formula is",
enter this formula:

=$A1<>$B1

click format, and select a pattern to shade the cells.

-Dave
 
Back
Top