I have a master row that I would like to track the year's progress. In my image,
I would like the [Status] ball to stay Green if "YES" and if blank in [Count] cells January - December. Want it to turn Red, if there is a "NO" in any [Count] cell. If all [Count] cells are blank January - December then "Blue"
YES followed by blank =Green
Any NO =Red
All blank=Blue