+ Reply to Thread
Results 1 to 6 of 6

Chnage Cell color if data modify

  1. #1
    Registered User
    Join Date
    04-02-2017
    Location
    Ahmedabad
    MS-Off Ver
    2010 & 2016
    Posts
    14

    Post Chnage Cell color if data modify

    Hi All,

    I am using google spreadsheet shared with 5-6 people, i want to know that is there any code or formula that if value in a particular cell in modified by any user than the color of cell get changed.

    Or is it possible to get details by which user data get modified with name, date and time stamp.

    Thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Chnage Cell color if data modify

    Not with regular formulas, no. But you may be able to do that with VBA, Im not sure if Docs will be able to do that though
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-02-2017
    Location
    Ahmedabad
    MS-Off Ver
    2010 & 2016
    Posts
    14

    Re: Chnage Cell color if data modify

    can you share the vba code for that with sample excel sheet.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Chnage Cell color if data modify

    you can try:

    open new workbook
    click on TAB right mouse button
    select View Code
    paste VBA into blank window
    close VBA window
    save workbook as xlsm file (macro enabled)
    Please Login or Register  to view this content.
    if you add/change value in A column you will see timestam in col B

    adapt to your needs

  5. #5
    Registered User
    Join Date
    04-02-2017
    Location
    Ahmedabad
    MS-Off Ver
    2010 & 2016
    Posts
    14

    Re: Chnage Cell color if data modify

    Hi Sandy,

    Thanks for your help, but i want to identify the user who has done the modification in shared google spreadsheet.
    this code doesn't work in google spreadsheet.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Chnage Cell color if data modify

    To me OR means OR
    Or is it possible to get details by which user data get modified with name, date and time stamp.
    Like Ford said
    Not with regular formulas, no. But you may be able to do that with VBA, Im not sure if Docs will be able to do that though
    you need check it by yourself

+ 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. Modify Cell Background Color based on cell content
    By CWDurkin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2014, 11:57 AM
  2. [SOLVED] Modify Current VBA Cell Background Color Code
    By boldcode in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2011, 02:29 AM
  3. Replies: 3
    Last Post: 12-12-2009, 02:26 PM
  4. Modify Code to change cell background color
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2008, 12:54 AM
  5. cell color after modify
    By flyingmunky25 in forum Excel General
    Replies: 1
    Last Post: 04-09-2008, 04:08 PM
  6. Is there a way to chnage cell formulas to VBA module?
    By excel_2007_user in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2007, 11:58 AM
  7. Replies: 4
    Last Post: 12-04-2005, 12:30 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