View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Compare multiple cells and highlight differences

Assuming your lists are in columns A and B, you can put this formula in
column C (assuming first entry is on row 2), and copy/fill it down the sheet:

=IF(A2<B2,"NOT EQUAL","")

Or, you can do it with conditional formatting:

Select all of the cells in the 2nd column. Choose Format -- Cells --
Conditional formatting
Choose Cell Value Is and "not equal to" and then move to the last entry area
and click on the topmost cell in the first column (as A2). Now, Excel is
going to enter a formula in that last entry area like =$A$2. Click right
next to that 2nd $ symbol and delete it so that the formula looks like =$A2.
Then use the [Format] button to set special formatting and click the [OK]
buttons to exit the tool. Cells in the 2nd column that are not equal to the
one on the same row in the first column will take on the special format you
chose.


"ez" wrote:

Hello,

I have two long lists (same template) I need to compare cell to cell (on the
same row) to find any differences. It there an easy way to compare the two
lists and have the system to highlight the cells that are different? Again
note that the comparison is between cells similarly positioned in the two
lists.
Thanks,
Elena