# 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?
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
0
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
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.