My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up as follows: 

1. Is the capital expenditure request a 2020


So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want:

If one of the dependencies has a red color ball, I want the parent ball color to be red.

If all dependencies have a green ball, I want the ball for the parent to be green