Be aware: In the data hierarchy, small children will not inherit conditional formatting from the mother or father, and also the mum or dad won't inherit conditional formatting from the children.This very last example employs the INDEX and MATCH functions together to return the earliest invoi