Look at multiple yes, no responses

I would like for field to look at a range of yes/no/n/a questions then change the value to yes of all responses are yes or yes's and n/a. change value to red if a no is in the range. also want the filed to be blank by default. see attached.