Solved

Excel 2 worksheet to compare.

Posted on 2011-02-25
7
274 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Gonzalo Becerra
  • 4
  • 2
7 Comments
 
LVL 8

Expert Comment

by:pdd1lan
ID: 34979189
0
 
LVL 50

Expert Comment

by:teylyn
ID: 34979205
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
 
LVL 1

Author Comment

by:Gonzalo Becerra
ID: 34979264
Is for excel 2007. it's the same?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 1

Author Comment

by:Gonzalo Becerra
ID: 34979297
How can I compare this two sheets in excel 2003?
0
 
LVL 1

Author Comment

by:Gonzalo Becerra
ID: 34981208
How can I compare this two worksheets in excel 2003 please?
0
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
ID: 34984990
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
 
LVL 1

Author Comment

by:Gonzalo Becerra
ID: 34989019
Thanks a lot!!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Outlook Free & Paid Tools
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now