+ Reply to Thread
Results 1 to 3 of 3

Highlighting Duplicate Date Using Two Cells

  1. #1
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    Highlighting Duplicate Date Using Two Cells

    Hello,

    Not sure if this needs to be in the VBA section or if it can just be setup via 'Rules'.
    I have a tracker that lists numerous devices. The tracker has two columnns of interest, Column A: "Device" and Column B: "IP".
    I cannot upload the actual tracker but for the purpose of trying to explain this better I have an example.


    A normal Rule will look at each column individually and highlight duplicate cells in that column. What I want to do is highlight the duplicate based on both columns together, kinda like forcing Excel to look at both columns together.

    I have attached the example sheet to try and make this garble a little easier to understand.

    Thanking you in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,519

    Re: Highlighting Duplicate Date Using Two Cells

    Conditional Format?

    Formula
    =COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,$B2)>1

  3. #3
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    Re: Highlighting Duplicate Date Using Two Cells

    Sorry for the VERY late response but jindon that works great. Thank you :-)

+ 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. Highlighting Duplicate cells?
    By Rexx372 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2017, 07:09 PM
  2. Replies: 1
    Last Post: 05-17-2014, 05:44 PM
  3. Highlighting Duplicate Cells
    By vinceancona in forum Excel General
    Replies: 5
    Last Post: 09-28-2013, 02:22 PM
  4. [SOLVED] Highlighting Duplicate Cells
    By paodelol in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-11-2013, 11:15 AM
  5. Finding duplicate cells and highlighting them
    By masond3 in forum Excel General
    Replies: 5
    Last Post: 08-07-2012, 08:35 AM
  6. highlighting duplicate cells
    By langdon37 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2009, 05:58 AM
  7. How to Highlighting duplicate ALL cells on A:A column with red ?
    By yannipr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-19-2008, 04:08 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