+ Reply to Thread
Results 1 to 4 of 4

Format cells in a worksheet that are changed in the last 15 days

  1. #1
    Registered User
    Join Date
    04-24-2014
    Location
    Willowbrook, USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Format cells in a worksheet that are changed in the last 15 days

    Can conditional formatting used to highlight cells that are changed in the last 15 days?

    I know we can use track changes, but I am looking to highlight cells that are changed in the last 15 days all the time.

    Appreciate your help!

    Thanks,

    Pavan.

  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,929

    Re: Format cells in a worksheet that are changed in the last 15 days

    If you have a date that goes along with the change, then we can use that with todays date in CF. However, if it is just some cell that was changed, then, apart from VBA, we have no way to know when the change was made
    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-24-2014
    Location
    Willowbrook, USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Format cells in a worksheet that are changed in the last 15 days

    Thanks for you reply. Can the VBA code highlight the cells for certain period of time? If so, could you please help with VBA code? Apprecite your help!

  4. #4
    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,929

    Re: Format cells in a worksheet that are changed in the last 15 days

    My VBA sucks, but I will move this to the VBA forum for you

+ 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. Replies: 4
    Last Post: 10-23-2012, 01:53 AM
  2. Replies: 3
    Last Post: 01-09-2012, 01:39 PM
  3. Lock cells in worksheet after they are changed
    By eherron in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2011, 04:24 PM
  4. identifying changed cells within a worksheet
    By davemcguire in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2011, 09:39 AM
  5. Replies: 7
    Last Post: 06-12-2009, 03:56 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