+ Reply to Thread
Results 1 to 5 of 5

Auto add borders to duplicates?

  1. #1
    Registered User
    Join Date
    01-03-2021
    Location
    Indiana
    MS-Off Ver
    365
    Posts
    30

    Auto add borders to duplicates?

    Hi, I have a long sheet and need to find all the duplicates and add a border those rows.

    I was able to highlight all the rows with duplicates using a Kutools feature.
    highlighted rows.png

    How can I have excel find the duplicates and put boxes around them like this?
    Highlight with borders.PNG

    Thank you
    Kim

  2. #2
    Banned User!
    Join Date
    01-17-2021
    Location
    Omaha, NE
    MS-Off Ver
    office 2016
    Posts
    211

    Re: Auto add borders to duplicates?

    you can not. excel does not have 2-fold feature like this. nothing that can format anything in excel can find duplicates at the same time. have to code it to do it one step

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,596

    Re: Auto add borders to duplicates?

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    387

    Re: Auto add borders to duplicates?

    could you use conditional formatting ? select the data you want to show as duplicate - go to conditional formatting > highlight cell rules > Duplicate values > decide what fill and text colour you want or press the small down arrow and select custom format and press ok

    hope this helps

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,640

    Re: Auto add borders to duplicates?

    I don't know about Kutools but everything you are showing can be done with Conditional Formatting.

    You will have one rule to highlight duplicates in the desired fill color.

    You will have one rule that says if the row above is not a duplicate, and the row below is a duplicate, show a border along the top

    You will have one rule that says if the row above is duplicate, and the row below is not a duplicate, show a border along the bottom

    I can implement in your file if you attach it. See yellow banner at the top of the page.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Auto Summing left within borders
    By GurungBoi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-17-2016, 12:13 PM
  2. [SOLVED] Auto change borders to thick borders
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-22-2013, 11:17 PM
  3. Auto size and remove borders from Excel charts
    By 2lkopp3n in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2012, 09:57 AM
  4. Auto makeing of borders
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2011, 08:23 AM
  5. Auto-sizing a list surrounded by borders
    By Fitur in forum Excel General
    Replies: 0
    Last Post: 01-04-2011, 12:05 PM
  6. Loop Macro to Auto Format Borders
    By algirard8 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-19-2010, 09:03 AM
  7. Auto Borders
    By Mike in forum Excel General
    Replies: 0
    Last Post: 02-01-2006, 02:30 PM

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