Changing the ball color on parent based on color of children

Jeff Smith

What I am trying to do is change the color of the RYG ball to red if any of the children have a red ball else leave it blank.

Jeff Smith

I was able to figure this out on my own. =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", "")