+ Reply to Thread
Results 1 to 4 of 4

Draw border when date in column A changes

  1. #1
    Forum Contributor
    Join Date
    10-06-2017
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    123

    Draw border when date in column A changes

    Dear all,

    I need a small formula to draw a border when date changes.
    Things are as follows:
    - on column A i have a lot of dates (01.01.2019, 02.01.2019, 03.01.2019, etc). Some of the dates are repeating (01.01.2019, 02.01.2019, 02.01.2019, 03.01.2019, etc)
    - i need a formula that draws a border from column A to column C when date in column A changes.
    I tried to do it with conditional formating, but no result...

    A l B l C
    01.01.2019 l 123 l 456
    02.01.2019 l 789 l 451
    02.01.2019 l 452 l 778
    ------------------------------------
    03.01.2019 l 555 l 369
    03.01.2019 l 137 l 691
    ------------------------------------
    04.01.2019 999 777

    Thank you in advance

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: Draw border when date in column A changes

    You can add border top for cell A/B/C if next date is different than above. Check attached file.
    Imho you won't be able shift data (add empty row as separator) without VBA.
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    10-06-2017
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    123

    Re: Draw border when date in column A changes

    Thank a lot KOKOSEK.
    It works perfectly. Such a simple solution.

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: Draw border when date in column A changes

    You welcome.
    If you happy with solution, please use Thread Tools and mark it as SOLVED.

    p.s. I will appreciate if You also add reputation point.

+ 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. Need macro to draw border
    By indjb in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-31-2017, 04:38 PM
  2. Draw a border based on current month
    By JT_2111 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2014, 06:44 PM
  3. Pivot table draw border based on order number
    By Risto85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2014, 08:56 AM
  4. Draw bottom border on every rows from top to bottom
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-08-2013, 09:52 AM
  5. How to write a Series (Sr.No) & Draw Border for Spaced Data using VBA?
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2011, 07:52 AM
  6. Using a macro to draw the cell border
    By Jeroen1000 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-30-2009, 10:06 AM
  7. [SOLVED] Erase & Draw Border functions no longer work
    By bob m in forum Excel General
    Replies: 2
    Last Post: 02-25-2005, 02:06 PM

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