Results 1 to 8 of 8

Highlight duplicates - two sheets - based on two cell values

Threaded View

  1. #1
    Registered User
    Join Date
    02-17-2021
    Location
    Helsinki, Finland
    MS-Off Ver
    365
    Posts
    31

    Highlight duplicates - two sheets - based on two cell values

    I have an excel which has 2 sheets. Need to highlight (the whole row) on the Target Group-sheet, information (criteria:street address, firsts & last name match) that is on "contacted-sheet".
    As there is no key identifier, I thought if Street Address and Names could be criterias to be used for matching?

    As a user I want to see on my marketing campaign target group, which of these persons have contacted.

    I tired conditional formatting but for some reason it does not work (=Countif). Would appreciate any help.
    Sample file enclosed.
    Thanks!
    Attached Files Attached Files
    Last edited by Tsinos; 06-09-2022 at 02:24 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to highlight duplicates across various sheets
    By locksyness in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2021, 10:44 AM
  2. Highlight duplicates across 2 sheets
    By mhope in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2020, 11:52 AM
  3. VBA to highlight duplicates over 2 sheets
    By Spoonman667 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-20-2019, 11:52 AM
  4. Replies: 1
    Last Post: 02-06-2019, 09:58 AM
  5. How to highlight duplicates in google sheets?
    By ImranBhatti in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-16-2017, 11:37 AM
  6. Compare on 2 sheets based on values in a 3rd sheet and highlight mismatches
    By Sirilias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2016, 10:21 AM
  7. Replies: 1
    Last Post: 09-28-2011, 07:42 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