First, research "Survey" here in this forum. Getting the correct table structure and relationships can save you hours of time here when it comes time to analyze your responses.
Second, one favorite suggestion of LaRetta's makes a lot of sense here:
Define the response field as a number field and set up a value list for your yes no field to enter 1 or 0 rather than yes or now. That makes counting the yes responses as easy as simply using a summary field to total up the value of this field across all the response records for this individual. You can edit your layout to resize the yes/no field to hide the numbers and add layout text for the yes and no labels.
Conditional format expressions can be used to provide your color coding when the summary field computes a sub total in the desired ranges. (Use Get Summary may be needed if you bring up responses for more than one respondant at a time.)