Highlight Duplicate values by not highlighting any one of its parent value

  • Hi all,
    Hope everything is fine.


    Requesting anyone to help me in achieving my requirement.


    Just for my explanation I have attached a sample of my excel file. Kindly look into it.


    I have shown the sample in 2 different sheet. One is Using highlight duplicate values from conditional formatting and the other sheet I done manually just for better understanding.


    My requirement is that,


    In Column 'B', I have certain values which are duplicated and some aren't. Is there any method or any command wherein it should highlight only the children values. From the repeated values, anything can be children and anything can be parent irrespective of the other columns.


    Example:
    In column B, mfngb1 is used 4 times. When used conditional formatting and highlight Duplicate values, it highlights all the 4 cells. But I need only 3 to be highlighted leaving behind one cell unhighlighted (Any 1 out of those 4 can be unhighlighted).

    Similarly, mfngb2 is used 5 times. When used conditional formatting and highlight Duplicate values, it highlights all the 5 cells. But I need only 4 to be highlighted leaving behind one cell unhighlighted (Any 1 out of those 5 can be unhighlighted).


    In general, the unhighlighted values must be unique values.


    If the value is not repeated, it shouldn't highlight that value.


    Thanks in advance for your time.

  • Re: Highlight Duplicate values by not highlighting any one of its parent value


    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    *

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!