Help with Conditional Formatting For Creating Multiple Choice Drop Down Test

So I am creating a multiple choice drop down test in excel and I want to make it where the cell would change to the color green if I get the answer right and red if I get it wrong. I know how to do it for each cell individually but that would take a VERY long time.

So what I thought I could do is make a copy of the column in a another spreadsheet (Label Answer) and make column in the test page (Label Test) change color based on the answer on the other spreadsheet.

Who what I did was create a new rule in the on the Answer column in "Test" page to change to the color green if the text matches the cells in the on the answer column in the "Answer" page in the same excel file.

the problem is that this only work on the first question, any question after that doesn't change color at all.

This is all done using the "format only cell that specific text"

Here is my example for anyone that can help me out.

I have excel 2013

And I also have numerous other test with different number of questions. I want to be able to create tests like this moving forward for studying

Ok, that work when I copy past the formula into my existing cells. Thanks a lot.

this my be a stretch, and asking way too much more. But can you explain to me how to got that formula just in case I need to do something like this again with different columns and cell values?

so if I want to use column "C" to put my answer I would have something like this?

=VLOOKUP(B1,Answer!$B$1:$C$100,2,0)=C1

Ok so now that I figure out that I want to input the answer into column C on the Test page but also take the answer from column C on the Answer page, how would I write the formula?