I have created a Google Form which links to a spreadsheet. There is an option which asks for the person's name. For the answers in the sheet, I've created conditional formatting to highlight the correct answers.
=importrange(" xxxx ", "xxx!xxx" )
I want it to be able to import the names from the
name column that have answered all the questions correctly to another sheet if possible. I know the import code, however I need help with importing specific names that have all the cells highlighted with conditional formatting.