Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Conditional Formatting to identify Parent/Child Relationship

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-01 10:38, goodwisa wrote:
    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.
    It is unclear how the codes must be read to see a parent and the associated children. Care to elaborate how the codes encodes a parent and that parent's children?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-01 10:42, Aladin Akyurek wrote:
    On 2002-04-01 10:38, goodwisa wrote:
    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.
    It is unclear how the codes must be read to see a parent and the associated children. Care to elaborate how the codes encodes a parent and that parent's children?
    If the parent is a book with page numbers from 56147 to 56190, then children have pages that fit within that range (56150 to 56155, 56153 to 56154, etc.)

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-01 11:10, goodwisa wrote:
    On 2002-04-01 10:42, Aladin Akyurek wrote:
    On 2002-04-01 10:38, goodwisa wrote:
    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.
    It is unclear how the codes must be read to see a parent and the associated children. Care to elaborate how the codes encodes a parent and that parent's children?
    If the parent is a book with page numbers from 56147 to 56190, then children have pages that fit within that range (56150 to 56155, 56153 to 56154, etc.)
    Hope a VBA programmer will take this up from here, because you're bound by three conditions, thus three colors using Format|Conditional Formatting.

    Even with VBA, things might get difficult with lots of parents that must be colored differently along with their children.


  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-01 11:37, Aladin Akyurek wrote:
    On 2002-04-01 11:10, goodwisa wrote:
    On 2002-04-01 10:42, Aladin Akyurek wrote:
    On 2002-04-01 10:38, goodwisa wrote:
    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.
    It is unclear how the codes must be read to see a parent and the associated children. Care to elaborate how the codes encodes a parent and that parent's children?
    If the parent is a book with page numbers from 56147 to 56190, then children have pages that fit within that range (56150 to 56155, 56153 to 56154, etc.)
    Hope a VBA programmer will take this up from here, because you're bound by three conditions, thus three colors using Format|Conditional Formatting.

    Even with VBA, things might get difficult with lots of parents that must be colored differently along with their children.


  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-01 11:37, Aladin Akyurek wrote:
    On 2002-04-01 11:10, goodwisa wrote:
    On 2002-04-01 10:42, Aladin Akyurek wrote:
    On 2002-04-01 10:38, goodwisa wrote:
    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.
    It is unclear how the codes must be read to see a parent and the associated children. Care to elaborate how the codes encodes a parent and that parent's children?
    If the parent is a book with page numbers from 56147 to 56190, then children have pages that fit within that range (56150 to 56155, 56153 to 56154, etc.)
    Hope a VBA programmer will take this up from here, because you're bound by three conditions, thus three colors using Format|Conditional Formatting.

    Even with VBA, things might get difficult with lots of parents that must be colored differently along with their children.

    It's okay for the parents to be the same color and for the children to be a different color, so it might still be possible to use conditional formatting.

Some videos you may like

User Tag List

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
  •