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.
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.