Need help on how to highlight duplicated entries and missing data.
Results 1 to 3 of 3

Thread: Need help on how to highlight duplicated entries and missing data.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2005
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need help on how to highlight duplicated entries and missing data.

    Hi

    I have a workbook that that has data in rows B-E and I-L .

    What im trying to do is to highlight duplicated entries and missing data. What I need to do is for it to look down columns B-E and then look down columns I-L and if any data missing I need the row in columns B-E highlighted. What I mean by looking for data is that the entry in in columns B-E MUST be an exact match in columns I-L to avoid it being highlighted.

    All entries in columns B-E will not be in the same row as columns I-L so I need it to look all the way down columns I-L when comparing with a entry in columns B-E.

    When it completed I then need it to look down columns I-L and see if there are any duplicated entries and again highlight in columns I-L .

    Any Ideas?

  2. #2
    New Member
    Join Date
    Dec 2016
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help on how to highlight duplicated entries and missing data.

    Conditional formatting for duplicates. For Missing data - Put data in a filtered list, sort by blanks

  3. #3
    New Member
    Join Date
    Jul 2005
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help on how to highlight duplicated entries and missing data.

    Conditional formatting OK

    Confused put in a filtered list and sort by blanks? What do you mean.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •