RYG Ball Automation

Melissa Appleman

Hello,

I am trying to automate RYG ball based on Y/N responses to other cells OR I could change the Y/N to also be RYG if that would make this possible.

Essentially, my overall goal is to automate the RYG ball based on how 26 other fields are answered --

13 or less are green = Red

14-19 Green = Yellow

20-26 Green = Green

Is this possible?

Paul Newcome

Do you mean 13 or less Y, 13 or less N, or 13 or less overall answers?