Results 1 to 2 of 2

Highlighting Duplicate Data Using Two Cells

Threaded View

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

    Highlighting Duplicate Data Using Two Cells

    Hello,

    I am trying to set-up conditional formating based on data within two columns. I have attached an example that will hopefully explain things better.

    I have two columns, for the benefit of this example, Column A holds computer names and Column D holds dates.
    I want to highlight any duplications in Column A (computer names) if the cell in Column D (same row) is empty. Once enter a date in that empty cell the highlighting for the duplication in Column A is removed.

    I have tried several formulas but just can't get it right
    =IF(AND(COUNTIFS($A$3:$A$10,$A3)>1,$B$2=""),TRUE,FALSE)
    =IF(AND(COUNTIFS($A$3:$A$10,$A3)>1,$B$3:$B$10,"")>1),TRUE,FALSE)
    I have tried the brackets in different lcoations within the forumlas and I've also tried other varitaions (but don't have them listed to show)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Highlighting Duplicate Date Using Two Cells
    By mowens74 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2018, 04:50 AM
  2. Highlighting Duplicate cells?
    By Rexx372 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2017, 07:09 PM
  3. Replies: 1
    Last Post: 05-17-2014, 05:44 PM
  4. Highlighting Duplicate Cells
    By vinceancona in forum Excel General
    Replies: 5
    Last Post: 09-28-2013, 02:22 PM
  5. [SOLVED] Highlighting Duplicate Cells
    By paodelol in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-11-2013, 11:15 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