+ Reply to Thread
Results 1 to 5 of 5

Highlight duplicate in multiple sheets

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Highlight duplicate in multiple sheets

    Hello

    I have attached demo file with sheets names B2, B3 and B4.

    I need to highlight duplicates of column A across all three sheets. How to do this please
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    05-13-2023
    Location
    Venera
    MS-Off Ver
    2007
    Posts
    79

    Re: Highlight duplicate in multiple sheets

    You can select column A and use Conditional formatting -> Highlight Cells Rules -> Duplicate values

  3. #3
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Re: Highlight duplicate in multiple sheets

    I need to check duplicate across three sheets whether any sheet has common name in column A

  4. #4
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Re: Highlight duplicate in multiple sheets

    I meant all three sheets it should check for duplicate

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Highlight duplicate in multiple sheets

    Three conditional formatting rules:
    1. On the B2 sheet: =SUM(COUNTIFS('B3'!A$3:A$100,A2),COUNTIFS('B4'!A$3:A$100,A2))>0
    2. On the B3 sheet: =SUM(COUNTIFS('B2'!A$3:A$100,A2),COUNTIFS('B4'!A$3:A$100,A2))>0
    3. On the B4 sheet: =SUM(COUNTIFS('B2'!A$3:A$100,A2),COUNTIFS('B3'!A$3:A$100,A2))>0
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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 duplicate values in multiple sheets
    By Iftikhar Arain in forum Excel General
    Replies: 7
    Last Post: 06-06-2023, 09:14 AM
  2. Replies: 1
    Last Post: 05-11-2023, 02:01 AM
  3. Highlight based on duplicate values over several sheets?
    By Moonlit Shadow in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-07-2022, 10:52 AM
  4. [SOLVED] highlight duplicate values on multiple sheets in a workbook
    By Coventry G in forum Excel General
    Replies: 3
    Last Post: 10-07-2020, 08:30 AM
  5. Highlight duplicate values on multiple sheets
    By Justmegan93 in forum Excel General
    Replies: 1
    Last Post: 07-02-2015, 06:04 AM
  6. Replies: 8
    Last Post: 08-23-2013, 03:57 PM
  7. Highlight duplicate entries from multiple sheets
    By alinpion in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-17-2011, 06:22 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