+ Reply to Thread
Results 1 to 3 of 3

Loop that adds thick bottom border to row range

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    Lehigh Valley, PA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Loop that adds thick bottom border to row range

    Hi,

    Any help in accomplishing the follow is much appreciated.

    Loop that adds thick bottom border

    1) Loop through Column J
    2) If current cell and cell below current cell are dissimilar and both cells contain text (neither is empty), then seperate the row range column "B" through column "CH" with a thick bottom border.
    Attached Files Attached Files
    Last edited by msmick; 01-10-2012 at 11:43 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-05-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    308

    Re: Loop that adds thick bottom border to row range

    Hi there

    This could be achieved using Conditional formatting without the need for macros. I have done this in the attached file, in columns B:AC.

    To give you what you asked for:
    Please Login or Register  to view this content.
    Hope this helps.

    Cheers, Rob.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-28-2011
    Location
    Lehigh Valley, PA
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Loop that adds thick bottom border to row range

    Very Nice!
    Thank you Rob

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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