+ Reply to Thread
Results 1 to 7 of 7

Adding formatting to a dated group

  1. #1
    Registered User
    Join Date
    06-20-2022
    Location
    Greenfield, UK
    MS-Off Ver
    365 apps for business
    Posts
    4

    Adding formatting to a dated group

    Hi all, first post!
    I have a spreadsheet for work that is a list of jobs that are sorted in date order.
    Is there a formula or format option that will allow me to add a thick border to the last line of a specific date group just to make it easier to differentiate between individual date groups? sometimes its 3 in a week, sometimes up to 8 and if the dates change can it dynamically adapt and switch the line?
    These also use isoweek numbers
    Attached Files Attached Files
    Last edited by martinHB; 06-20-2022 at 12:03 PM. Reason: adding attachment

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

    Re: Adding formatting to a dated group

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    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
    06-20-2022
    Location
    Greenfield, UK
    MS-Off Ver
    365 apps for business
    Posts
    4

    Re: Adding formatting to a dated group

    Quote Originally Posted by TMS View Post
    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Hopefully I've got this correct, thanks in advance

  4. #4
    Registered User
    Join Date
    06-20-2022
    Location
    Greenfield, UK
    MS-Off Ver
    365 apps for business
    Posts
    4

    Re: Adding formatting to a dated group

    Resent to bump, file added

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,344

    Re: Adding formatting to a dated group

    See the updated sample file.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    06-20-2022
    Location
    Greenfield, UK
    MS-Off Ver
    365 apps for business
    Posts
    4

    Re: Adding formatting to a dated group

    Thank you so much for your response, but i already have this applied to differentiate between week numbers. I was wondering if its possible to have a thick bottom border after the last entry in that week just to aid the visual break up of the weeks, but for it to be dynamic so if i moved the last entry from 1 week to another, then the border would jump to the new final entry?

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,106

    Re: Adding formatting to a dated group

    If you change the weeknumber in column C it does just what you want (if I understand you...).

    However, how is week 2 13 days long???
    Glenn



+ 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: 0
    Last Post: 09-21-2020, 03:36 PM
  2. Adding a group within a existing group
    By blue blue blue in forum Excel General
    Replies: 4
    Last Post: 09-01-2020, 09:47 PM
  3. Replies: 3
    Last Post: 04-07-2016, 06:14 PM
  4. [SOLVED] Conditional formatting a cell if date is later than another dated cell
    By fumusic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2014, 06:50 AM
  5. Open multiple dated text files and import dated data specified in file name
    By andygxxxv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 03:56 PM
  6. Conditional formatting based on entered dated and how much time has passed
    By sanchez7315 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2012, 12:07 AM
  7. [SOLVED] help formatting cell with text "week of" and then the dated
    By heartofthehome in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2012, 08:27 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