Results 1 to 10 of 10

Need Macro to Compare Two Sheets with Same Columns Highlight Differences using Unique ID

Threaded View

  1. #9
    Registered User
    Join Date
    04-18-2013
    Location
    Miami, FL
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Need Macro to Compare Two Sheets with Same Columns Highlight Differences using Unique

    Ok here take a look at this. i've made a place for you to paste the data you have...up to 1000 rows. The other sheets read off of that. Take a look at the formula's in the conditional formating>manage rules... choose this worksheet, and you'll see how the formulas in here are basically like an if statement that control the formatting. Pay close attention to the hierarchy of the 3 conditional formatting formulas.

    Play around with it and let me know if you have any questions.

    br,
    Mike
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1