+ Reply to Thread
Results 1 to 17 of 17

Applying bottom borders

  1. #1
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Smile Applying bottom borders

    Good Afternoon,

    I need help with applying a thick bottom border under items that end in the code 'BX-3'.

    Instead of doing this manually (There are over 3000) products, I am wondering if there is a quick solution to this to make the different product ranges stand out/segregate.

    Please see attached image(If uploaded- not sure if its uploaded)

    Your help will be hugely appreciated.

    Kind Regards
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    520

    Re: Applying bottom borders

    try this:

    Please Login or Register  to view this content.
    Last edited by ikboy; 11-03-2016 at 09:16 AM.

  3. #3
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    779

    Re: Applying bottom borders

    Hi Mitch.Birlea,

    The attached uses conditional formatting to achieve what you're after.

    Hope this helps.

    Regards,

    Snook
    Attached Files Attached Files
    Last edited by The_Snook; 11-03-2016 at 09:28 AM.

  4. #4
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Applying bottom borders

    Hi Snook,

    Thanks for this- Please could you advise me on how you came about doing this as ill need to apply it to my spreadsheet.

    Thanks for your help

  5. #5
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Applying bottom borders

    Hi Ikboy,

    Please can you explain what I have to do with this formula- (i.e copy+paste it?)

    Thanks for your help

  6. #6
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    779

    Re: Applying bottom borders

    1. Select the cells you want to format.
    2. Click Home > Conditional Formatting > New Rule.
    3. Click Use a formula to determine which cells to format.
    4. Under Format values where this formula is true, enter your formula.
    5. Click Format.
    6. Use the controls on the Number, Font, Border, and Fill tabs to change your data, or the cells around your data.

    For point four you need to write the formula from the perspective of the active cell. The active cell is shown in the 'name box' at the top left of the screen.
    For example if you select from cell A2 to the end of the range your formula will be =RIGHT($A2,3)="BX3"

    Regards,

    Snook

  7. #7
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Applying bottom borders

    Hi Snook,

    Thank you so much for your help.

    The concept is there but its underlining above 'BX3' therefore undlining 'BX2'.

    Could you recommend anything?

    So close to solving it

    Cheers

  8. #8
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    779

    Re: Applying bottom borders

    Hi Mitch.Birlea,

    I assume it's because the formula isn't written from the perspective of the active cell. It's difficult to diagnose without seeing an example. Is it possible to upload an extract of the data you're working with and I'll take a look?

    Regards,

    Snook

  9. #9
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    779

    Re: Applying bottom borders

    What formula have you input and what range does it apply to?

  10. #10
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Applying bottom borders

    Hi Snook,

    I have attached the spreadsheet in question so you can have a look at it

    Cheers

  11. #11
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    779

    Re: Applying bottom borders

    Hi Mitch.Birlea,

    There's no attachment.

    Snook

  12. #12
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Applying bottom borders

    Hi Snook

    Ive private messaged you

    look forward to hearing from you

    Cheers

  13. #13
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Applying bottom borders

    Ive done what was said on private message

    Has this worked?

    Cheers Snook
    Attached Files Attached Files

  14. #14
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    779

    Re: Applying bottom borders

    Yup I'll take a peek now.....

  15. #15
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    779

    Re: Applying bottom borders

    Hi Mitch.Birlea,

    Click on cell A2 and select Home -> Conditional Formatting -> Manage Rules
    Change the 'applies to' range to $A$2 rather than $A$1 and click apply.
    Then click 'edit rule' and change the formula to =RIGHT($A2 rather than $A3.

    That should resolve it.

    Snook

  16. #16
    Registered User
    Join Date
    09-09-2016
    Location
    Derby England
    MS-Off Ver
    Excel 2013
    Posts
    39

    Re: Applying bottom borders

    Hi Snook,

    This has resolved it now!! Thank you so much for your help and time I appreciate it so much!!

    thank you!!!!!!

  17. #17
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2016 H: 365
    Posts
    779

    Re: Applying bottom borders

    You're welcome Mitch.Birlea, happy to be of service.

    Snook

+ 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. Applying borders
    By grkchakri in forum Excel General
    Replies: 2
    Last Post: 10-31-2015, 04:32 PM
  2. Borders or Repeating Rows at Bottom
    By kpow in forum Excel General
    Replies: 2
    Last Post: 10-02-2012, 12:31 PM
  3. Put borders at top and bottom of each row, but not sides?
    By Moonbather in forum Excel General
    Replies: 2
    Last Post: 08-04-2012, 02:31 PM
  4. [SOLVED] Naming Range Between Top & Bottom Borders (2)
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2012, 09:23 PM
  5. bottom borders in a For Loop
    By CJ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2006, 10:30 PM
  6. Replies: 2
    Last Post: 03-27-2006, 02:55 AM
  7. Trouble applying borders in Excel
    By CGB in forum Excel General
    Replies: 7
    Last Post: 01-10-2005, 02:06 AM

Tags for this Thread

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