+ Reply to Thread
Results 1 to 18 of 18

how to highlight rows based on latest time stamp

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    how to highlight rows based on latest time stamp

    i have a macro which pastes the username and time stamp, every time a certain macro is used onto a worksheet. If sumitted multiple times, i have another column which identifies that the data has been previously submitted. I am interested in highlighting the row or somehow make the last submission stand out on the worksheet. In other words, the bold rows below need to soemhow stand out. Can someone please help me.

    RJ FemProfile 8/6/2012 18:59
    RJ FemProfile 8/6/2012 19:27 Previously Submitted

    RJ FemImplant 8/6/2012 19:45
    RJ FemImplant 8/6/2012 19:46 Previously Submitted

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    Do you want to highlight the rows in yellow?

    It will be good if you post your code here so we can make the required changes for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to highlight rows based on latest time stamp

    this is what i have so far
    any help is greatly appreciated

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

    ---------- Post added at 06:01 PM ---------- Previous post was at 06:00 PM ----------

    Do you want the LogM or LogS code to be edited?

  5. #5
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to highlight rows based on latest time stamp

    Log M
    Since log M is used when there are multiple submissions
    thanks

  6. #6
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    But i am not seeing any code to mark the data as bold. Was the bold highlight only meant as an example in your 1st post?

  7. #7
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to highlight rows based on latest time stamp

    yes sir, I do not have the slightest of clue on how to proceed. any direction would be appreciated

  8. #8
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    I think it will be better if you attach a sample file which you are using with your code.

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.

  9. #9
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to highlight rows based on latest time stamp

    the Log sheet will have the submissions, i talked about.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    So as per your attachment, all rows that show Previously Submitted should be marked bold?

  11. #11
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to highlight rows based on latest time stamp

    of all the submissions for a particular process (column B), only the last submission should be in bold (hence the time stamp logic).

  12. #12
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    Try this code
    Please Login or Register  to view this content.
    Put it in a standard module.

  13. #13
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to highlight rows based on latest time stamp

    but if there are multiple submissions, all the submissions except the first one are turning bold. I need only the last submission of that process to be bold.

  14. #14
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    I ran it on the sample file that you uploaded in post 9 and it works fine.

    It will check column B, as soon as it finds a different name in the current row compared to the previous row, it will mark the previous row bold.

  15. #15
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to highlight rows based on latest time stamp

    thanks for trying.

  16. #16
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    Is it working fine now?

  17. #17
    Registered User
    Join Date
    08-07-2012
    Location
    antarctica
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: how to highlight rows based on latest time stamp

    Like I said, for every distincy entry in column B, it needs to look at the stamp and make the latest entry bold. What you have sent me just makes the last entry bold irrespective of a distinct entry in column B. I appreciate the help.

  18. #18
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: how to highlight rows based on latest time stamp

    See the attached file. Its a copy of your file with the code input into a standard module. I see 2 lines marked in bold.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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