I would like to identify parent/child relationships in Excel by using conditional formatting.
Column 1 Column 2
GMAN-0056147 GMAN-0056190 (Parent)
GMAN-0056150 GMAN-0056155 (Child)
GMAN-0056153 GMAN-0056154 (Child)
I am able to identify the first child by using the mid function and comparing the 1st row against the second row, but am lost as to how I can write a formula to identify the second child and third and fourth, etc. This wouldn't be so hard, except that the number of children for a parent will not always be the same. Thanks in advance for your help.
This message was edited by goodwisa on 2002-04-01 10:41
Column 1 Column 2
GMAN-0056147 GMAN-0056190 (Parent)
GMAN-0056150 GMAN-0056155 (Child)
GMAN-0056153 GMAN-0056154 (Child)
I am able to identify the first child by using the mid function and comparing the 1st row against the second row, but am lost as to how I can write a formula to identify the second child and third and fourth, etc. This wouldn't be so hard, except that the number of children for a parent will not always be the same. Thanks in advance for your help.
This message was edited by goodwisa on 2002-04-01 10:41