Take note: In the data hierarchy, young children don't inherit conditional formatting from the father or mother, along with the parent will not inherit conditional formatting from the children. This previous case in point employs the INDEX and MATCH features jointly to return the ea