+ Reply to Thread
Results 1 to 2 of 2

Add borders based on merged cell height

  1. #1
    Registered User
    Join Date
    10-31-2016
    Location
    Malaysia
    MS-Off Ver
    2010
    Posts
    3

    Add borders based on merged cell height

    Hi All,

    Is there any way i could add a conditional formatting to add borders based on merged cell height? Attached the example of the border if it helps. Thanks!Borders.png

    ROW 2,3 & 4 are merged hence the horizontal borders are as shown.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Add borders based on merged cell height

    Why do you want to merge cells at all? They are a DISASTER in the body of the data. they make the application of formulae 100% + more difficult. If you need a row/column to be wider... widen it, but you should avoid the use of merged cells...
    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

+ 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. Different row height for two rows with a merged cell
    By MichelleP in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2016, 03:52 AM
  2. [SOLVED] Find Merged Cells and Format Cell Borders and Font
    By Lillian Bell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2015, 01:38 AM
  3. [SOLVED] Merged cell removes borders from where it is picked
    By jammergill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2013, 04:29 PM
  4. Automatically adjust row height in merged cell
    By jennifersmigla in forum Excel General
    Replies: 0
    Last Post: 03-16-2013, 01:15 PM
  5. [SOLVED] Merged Cell Conditional Formatting Borders
    By T Kirtley in forum Excel General
    Replies: 2
    Last Post: 06-01-2006, 02:45 PM
  6. Merged Cell Height
    By Roseanne in forum Excel General
    Replies: 2
    Last Post: 05-10-2005, 08:06 AM
  7. [SOLVED] Merged Cell Row Height
    By Jonny in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-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