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
Last edited by martinHB; 06-20-2022 at 12:03 PM. Reason: adding attachment
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
Trevor Shuttleworth - Retired Excel/VBA Consultant
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
Hopefully I've got this correct, thanks in advanceOriginally Posted by TMS
Resent to bump, file added
See the updated sample file.
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?
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
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks