+ Reply to Thread
Results 1 to 7 of 7

Comparison of relative data position rowwise & each cellwise of selected column

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Comparison of relative data position rowwise & each cellwise of selected column

    Hi,

    Currently I am facing a problem as how to compare which cell/s data has been changed.I have two worksheet namely "Old" & "New".I have kept only few data in these two sheet.Here,I want to highlight the changes in each row cell positions if it is changed in "New" sheet .

    I have made some changes in "New" sheet cell position which can be easy seen.

    I have a large data more than 30k rows all filled up.How this can be highlighted ?Also a summary if possible.
    If anyone require any further info,kindly let me know.

    I hope this could be resolved.

    Thanx in advance.
    Last edited by paradise2sr; 06-25-2017 at 01:15 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Comparison of relative data position rowwise & each cellwise of selected column

    If I understand correctly the following formula may be used as a conditional formatting rule to highlight rows in the 'New' sheet whose data has been changed as compared to the 'Old' sheet: =NOT(Old!$B5=$B5)
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Re: Comparison of relative data position rowwise & each cellwise of selected column

    I think it is not working.

    Kindly refer W6 & W7 of both "Old" & "New" sheet both are changed in "New" but it is not highlighted.Also take into consideration of addition/deleted of any data in "New" Sheet.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Comparison of relative data position rowwise & each cellwise of selected column

    Use this formula for the conditional formatting rule instead:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.

  5. #5
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Re: Comparison of relative data position rowwise & each cellwise of selected column

    Still not yet received desired result.Kindly,enclose the file.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Comparison of relative data position rowwise & each cellwise of selected column

    Here is the file with the conditional formatting rule applied. If it is not highlighted as desired, I would suggest uploading a sample that is manually highlighted so that we know how the finished product should look.
    Let us know if you have any questions.

  7. #7
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,238

    Re: Comparison of relative data position rowwise & each cellwise of selected column

    Still it has not been resolved.But I got help from http://www.vbaexpress.com/forum/show...835#post363835

    Hence,I am marking this thread as solved and thanx for your consistent support in trying to resolve my issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel VBA to extract data from relative position cells with respect to data cells
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2016, 12:36 AM
  2. [SOLVED] Arrange data columnwise to rowwise for each employee
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2015, 08:42 AM
  3. Macro to Hide a Column with a relative position
    By zhavier in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2014, 04:38 PM
  4. [SOLVED] Code for adding similar data rowwise
    By SParikh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2014, 06:09 AM
  5. Syntax of integer object in relative column position
    By Daniell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2013, 06:32 AM
  6. [SOLVED] converting columwise data to rowwise
    By semih in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2013, 08:45 AM
  7. Exclusive Lookup to match Rowwise data and give the Column Heading..
    By e4excel in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-26-2010, 04:00 AM

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