Excel 2 worksheet to compare.

Good morning,

 I need help comparing the 2 worksheet. I would like only to highlight the differences, how I can do? this is the excel sheet.

Thanks in advance,


Permissions.xls
LVL 1
Gonzalo BecerraSharePoint - Technical Lead for Operations & Engineering Team - Superrvising AssociateAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

In Excel 2003, you can do this:

- Select cell A1 in the second sheet (you need to select A1, or it will not work!!!)
- click Insert > Names > Define
- in the Names box enter the name CompareRange
- in the Refers to box enter

=PMICHLAUWEB57!A1

Note that there are no $ signs in that reference. It is (and must be) a relative reference.

On the first sheet, select A1, then extend your selection to include all your data, click Format > Conditional Formatting > Formula Is and enter the formula

=CompareRange<>A1

Select a format and hit OK.

Now all cells that are not the same as their counterpart on the other sheet will be highlighted.

see attached.

cheers, teylyn
Copy-of-Permissions.xls
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

in Excel 2010 you could select all cells in the first sheet, then add a conditional format with a formula

=A1<>PMICHLAUWEB57!A1

select a format and hit OK. The result would look like this

compare
In earlier versions of Excel, you cannot refer to other sheets in a conditional formatting formula, though.

cheers, teylyn
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Gonzalo BecerraSharePoint - Technical Lead for Operations & Engineering Team - Superrvising AssociateAuthor Commented:
Is for excel 2007. it's the same?
0
 
Gonzalo BecerraSharePoint - Technical Lead for Operations & Engineering Team - Superrvising AssociateAuthor Commented:
How can I compare this two sheets in excel 2003?
0
 
Gonzalo BecerraSharePoint - Technical Lead for Operations & Engineering Team - Superrvising AssociateAuthor Commented:
How can I compare this two worksheets in excel 2003 please?
0
 
Gonzalo BecerraSharePoint - Technical Lead for Operations & Engineering Team - Superrvising AssociateAuthor Commented:
Thanks a lot!!
0
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.

All Courses

From novice to tech pro — start learning today.