Find the correct answer from a file with old data to create a new file

I have a file with 790 pages of questions with four possible answers. The correct answer is the one that is selected in yellow or red. Your job is to select, the right answer (the yellow one) giving me back the file with only the correct answer, removing the 3 incorrect. For example: "Il minore emancipato può stipulare convenzioni matrimoniali? Sì, se è assistito dai genitori, dal tutore o dal curatore speciale No Sì No, salvo espressa autorizzazione del tribunale" You will find one of them in yellow… so you will select it, and, in the final file, you must write: Il minore emancipato può stipulare convenzioni matrimoniali? Sì, se è assistito dai genitori, Note 1: You will find questions with more of one ansie in yellow/red: in this case you must select the last one. Note 2: You will find questions with no answer in yellow/red: in this case, in the final file, you must write “EMPTY” Note 3: If you find a note, open it and you will find the right answer. Thank you.