I've looked through the forum but haven't found any solutions that match what I am trying to do.
I have created a form to ask band members whether they will be attending one of our events. Their responses populate the Form Responses 1 sheet in the document below. I've been trying to use Conditional formatting to have their names on the Summary sheet turn green (Attending) or red (Not attending). The idea was to match the name in the Summary sheet with the entries on the Form Responses sheet and have the color change based on their responses. If they haven't responded yet, the name in the Summary lists doesn't change. Is this possible? Thanks for any suggestions you may offer.