Compare two sheets and highlight/mark differences

**richarddd** · 04-03-2009, 02:37 AM

Hello.

I have two huge excel files, with many rows and columns, they "should" look the same.

But I need to find out if anything has been added or removed from the second one compared to the first one.

Which is the easiest way to accomplish this?

Searched this forum and Google but couldn't find what i was looking for.

Thanks in advance!

**oldchippy** · 04-03-2009, 03:34 AM

Hi,

Take a look here using Conditional formatting

http://spreadsheetpage.com/index.php...al_formatting/

**mubashir aziz** · 04-03-2009, 04:58 AM

Yup Conditional Formatting will play the role ....

**richarddd** · 04-03-2009, 09:51 AM

this should solve it! Thanks guys!

**oldchippy** · 04-03-2009, 09:54 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save