Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlight Differences (Excel 2003)

    Hi Hans,

    I have this code which highlight differences between 2 worksheets, but I noticed that the rows get highlighted based on column 1 and 2 if
    there are differences in the 2 sheets. It won't highlight if column 1 and 2 or 3 have the same data but column 4 have different data in the
    2 sheet. How can I modify the code to highlight the row as long as there is a differences in a row between the 2 sheets.

    TIA

    cheers, francis
    Attached Files Attached Files
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlight Differences (Excel 2003)

    Francis,

    Please don't direct questions at me personally. I may be the Lounge's most active poster, but there are many others who answer questions. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    The code doesn't really highlight differences, but values in one sheet that either don't occur in the other sheet or occur more than once. How do you want this to be extended to entire rows?
    Perhaps you could tell us what you want to use this code for, that might make it clearer.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlight Differences (Excel 2003)

    Hi Hans,

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> I want the code to highlight the rows on the first sheet it can't find the same data on the second sheet. I have attached a sample which show that the red highlighted rows was not in the second sheet, but it will not highlight the yellow row because the difference is
    in column C and not column A and B. Can the code to highlight the yellow highlighted row in sheet 1 as well since it is different from
    sheet 2 in column C? I need the code to extend to many more columns up to column O.

    Thanks for your help.

    cheers, francis
    Attached Files Attached Files
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlight Differences (Excel 2003)

    The attached version shows how it can be done with conditional formatting, without any code. The conditional formatting uses a defined name so that it can refer to values on another sheet.
    The sheet uses only three columns, but it can be extended to more columns.
    Attached Files Attached Files

  5. #5
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlight Differences (Excel 2003)

    Hi Hans,

    Thank for assisting. I will have a look at it and try extending to more columns.

    cheers, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

Posting Permissions

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