highlight differences

  1. A

    VBA for Highlighting Differences from 2 Sheets using Key Identifier

    I have 2 sheets (Sheet1 - New ; Sheet2 - Old) both sheets have a key identifier lets say in column B. I want to highlight the differences across each key identifier in sheet1 as compared to sheet2. If key identifier is new to Sheet1 - entire row should be highlighted Red. If there is any change...
  2. C

    VBA tool to create template to spot and highlight differences between two spreadsheets

    Hello, I have a VBA problem that i need help with. Scenario: We constantly receive spreadsheets from third parties which we use to record various metrics. The problem is that these spreadsheets are supposed to have the same headings and format to fit our set template but do not. It takes time...
  3. C

    Highlight Postcodes in XML Files

    Hi All, I have a small excel problem that I need a little help with. I have a Spreadsheet that contains part of a postcode in column A to be exact the data is between A3 and A63 although there is potential for this to expand. The column contains either the first part of the postcode OL7...
  4. S

    Loop through several excel files and compare parts of these files with Original Template

    Hello, This may sound a little bit complex, but I am looking for a Code that would Loop through all excel files in a Folder and: - on each excel workbook perform a check of Worksheet names with the Original template (order is not important although I can easily sort it if needed) - on each...
  5. A

    Using Conditional Formatting to find data from multiple worksheets

    I currently have a workbook with two worksheets inside of it that has some of my clients names in both. Some matching, and some missing. I would like to use conditional formatting (or some other search method) to search "Sheet A" for names not found in "Sheet B" and highlight/format these names...
  6. E

    How to compare and highlight differences in 2 spreadsheets?

    MS Word has a built in feature. Does MS Excel also have such a built in feature? If yes, where? If no, I see there exists third-party software add-ins that display and highlight the differences when comparing 2 spreadsheets. Which would be a good and free one?

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top