I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children.

I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for


I am looking for a Parent / Child formula to capture a status change (R / Y / G). The Parent status will change based on the Child status Change.

For example:

If I change the status of "Software" to Red (R) in the child row, it should change the Parent status to Red.

The parent row captures any