+ Reply to Thread
Results 1 to 6 of 6

Excel 2010 Identifying data changed in cells and Identifying the changed rows

  1. #1
    Registered User
    Join Date
    08-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Excel 2010 Identifying data changed in cells and Identifying the changed rows

    I have a large spreadsheet and need to visually see any changes made to the data on it. I also need to be able to identify by a column which rows have changed. All I have now is the below and it's not exactly what I'm looking for as it will change the fill and font color even if you retype the same thing in the cell. I only need it it do that if the data itself has changed.

    I have no clue as to how to put a 'Y' in a cell column if any data on that row has changed.

    Please help.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by SandyLake; 08-11-2013 at 09:32 AM. Reason: As per Forum Rule #3, please use code tags…Thanks.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,896

    Re: Excel 2010 Identifying data changed in cells and Identifying the changed rows

    Define a global variable and use a selection change event to store the current/previous value when a cell is selected. Then, if/when the cell changes, compare the new current value to the previous value. If they're different use your highlighter code.

    And use
    Please Login or Register  to view this content.
    for example to set the flag for the row.


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    08-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel 2010 Identifying data changed in cells and Identifying the changed rows

    Thanks Trevor, I understand the logic...I'm having problems with the syntax. Would you mind helping me out with that? Sorry to be a pain

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,896

    Re: Excel 2010 Identifying data changed in cells and Identifying the changed rows

    Something like this:

    Please Login or Register  to view this content.

    Regards, TMS

  5. #5
    Registered User
    Join Date
    08-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel 2010 Identifying data changed in cells and Identifying the changed rows

    Awesome and Thank you so very much!!!

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,896

    Re: Excel 2010 Identifying data changed in cells and Identifying the changed rows

    You're welcome.


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


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    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


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Exporing Data from Excel 2010 to an Outside Program to be Imported Back Once Changed
    By DakotaRoss in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2013, 09:57 AM
  2. Hiighlight the changed cells which are changed with the linked wookbook?
    By lb1900 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-09-2012, 12:26 PM
  3. identifying changed cells within a worksheet
    By davemcguire in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2011, 09:39 AM
  4. Identifying changed rows
    By slonus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-09-2008, 03:28 AM
  5. [SOLVED] Identifying a cell that has changed
    By avian2@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-14-2005, 05:05 PM

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