+ Reply to Thread
Results 1 to 6 of 6

Add Thick Border between Specified Rows, when Criteria Changes

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Add Thick Border between Specified Rows, when Criteria Changes

    Hello, have a quick one here where I need to add a thick bottom border between rows where the "grade" changes. So when a value in column B is different from the value above, there should be a thick bottom border added to the full row. This allows for sectioning for the eyes between "grades."

    The attached shows a before and after sample on subsequent tabs. Thanks for any assistance!

    Sheryl
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Add Thick Border between Specified Rows, when Criteria Changes

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Re: Add Thick Border between Specified Rows, when Criteria Changes

    Awesome, thank you!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Add Thick Border between Specified Rows, when Criteria Changes

    You're welcome & thanks for the feedback

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Add Thick Border between Specified Rows, when Criteria Changes

    @ Fluff13,

    Nice one!

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Add Thick Border between Specified Rows, when Criteria Changes

    @Winon
    Thanks for that

+ 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. [SOLVED] Conditional Formatting - Thick Border?
    By fedude in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-03-2023, 01:17 PM
  2. [SOLVED] Add thick Border around range after deleting empty rows - MACRO
    By davitali in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-11-2018, 12:48 AM
  3. Automatic Thick Border
    By Yanezez in forum Excel General
    Replies: 5
    Last Post: 09-25-2015, 02:40 PM
  4. Conditionally make thick border
    By gmcconnell in forum Excel General
    Replies: 1
    Last Post: 10-26-2011, 02:21 PM
  5. Need macro to add thick box border to certain cells - THANKS FOR THE HELP!!!
    By Jeff M in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2011, 09:57 AM
  6. Thick Top Border
    By scotfitz in forum Excel General
    Replies: 2
    Last Post: 05-11-2009, 10:42 AM
  7. How to keep Thick border when filtering
    By Zyphon in forum Excel General
    Replies: 1
    Last Post: 01-03-2008, 06:09 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