# Comparing a range of colums in Excel

Experts,

I have a range of columns B - BU.   Column  A has an ID.

Is there a way to highlight by a formula or  VB code  each column by ID where there the values are not equal with ID.  There are two rows per ID.

An example is H2 and H3  and I2 and I3.

Diffs.xlsx
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Finance AnalystCommented:
In cells A15:A18 copy your member IDs and then in cell B15 put this formula:

=IF(INDEX(B\$1:B\$9,MATCH(\$A15,\$A\$1:\$A\$9,0))=INDEX(B\$1:B\$9,MATCH(\$A15,\$A\$1:\$A\$9,0)+1),"","Check")

You can then copy that across to column BU and down to row 18.

Where there are differences there will be the word "Check".

Thanks
Rob H
Commented:
It's simple..if your data is sorted like this..you can simply apply this formula..

Go to Home-->Conditional Formatting-->New Rule-->Use formula to determine...

In B2 simply apply this formula-->=B2<>B3
and in B3 do the above steps and simply apply the same formula-->==B2<>B3

and use your paint brush to copy paste to other cells and their you go you are set..

Enclosed is your workbook..post i have applied conditional formatting...

Saurabh...
Diffs.xlsx

Experts Exchange Solution brought to you by