+ Reply to Thread
Results 1 to 7 of 7

Need to Highlight Duplicate Rows Fully

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    208

    Need to Highlight Duplicate Rows Fully

    Sir, I need to high light duplicate 4 rows as marked in excel attachment
    Attached Files Attached Files
    Last edited by maddyrafi1987; 03-03-2022 at 03:29 AM.

  2. #2
    Forum Contributor
    Join Date
    05-09-2021
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    110

    Re: Need to Highlight Duplicate Rows Fully

    Hi There,

    It is not clear what you want to achieve, the rows highlighted in your example are not duplicate..

  3. #3
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    208

    Re: Need to Highlight Duplicate Rows Fully

    Please check now I have attached the correct excel file, I want to compare 3columns and rows and highlight the same rows that already having previously

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,648

    Re: Need to Highlight Duplicate Rows Fully

    You've missed a pair!

    CF rule for B2:

    =COUNTIFS($B$2:$B$14,$B2,$C$2:$C$14,$C2,$D$2:$D$14,$D2)>1

    Applies to: $B$2:$D$14
    Attached Files Attached Files
    Last edited by AliGW; 03-03-2022 at 03:42 AM. Reason: Workbook attached.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,648

    Re: Need to Highlight Duplicate Rows Fully

    Are we there yet?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,648

    Re: Need to Highlight Duplicate Rows Fully

    Gone and not even a 'thank you'???

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

  7. #7
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    208

    Re: Need to Highlight Duplicate Rows Fully

    Thank you so much, formula is working very nicely. thanks a lot mam

+ 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. Highlight or display duplicate rows not duplicate values
    By olga6542 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2019, 03:24 PM
  2. Highlight Duplicate Rows based on Value on 2 different Columns
    By sunil31 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2019, 04:56 AM
  3. highlight duplicate rows
    By VBisgreat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-11-2016, 09:30 AM
  4. [SOLVED] highlight duplicate rows using textbox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-04-2013, 12:53 PM
  5. Highlight and count duplicate rows
    By dmc31 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2012, 01:37 PM
  6. Highlight rows based on Duplicate with conditions
    By ypnOz in forum Excel General
    Replies: 5
    Last Post: 12-28-2010, 09:50 AM
  7. highlight duplicate rows
    By dan2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2010, 04: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