Compare two Columns and Highlight

Been working on this for a while with too many hours of googling.

So basically, this is a quiz that's being made, Column O has a drop down menu for A, B, C or D (for the answer to the question) and Column Q has the answer.

What I am trying to do is whoever takes the quiz has to answer all 100 questions and then can click the Score button, I need it to highlight the correct answers Green and the Wrong answers Red.

So if O3 through O102 has the same answer as Q3 through Q102, highlight green, else highlight red. Closest I can get is it works once but anytime I use the drop down and select an answer, it highlights red or green.

Hello,

could you provide a file with one question and the 'Score' button?

As much as I can, had to take a lot out because of the questions that would be in it.

I want the commandbutton be the button that needs to be clicked to calculate. The calculation is already set to manual. I'm not sure where the two ActiveWorkbook needs to go

Ok. Something probably went wrong with security settings and the calculation was Automatic when I opened the workbook.
The two ActiveWorkbook are just in case something is not calculated correctly before the beginning of the test.

Why don't you call ConditionalFormat function at CommandButton22_Click.
Also, why do you use Application.Volatile in ConditionalFormat function? This makes the ConditionalFormat function to be called every time recalculation occurs.

I didn't build this whole thing. Just trying to help out on getting the CommandButton to work. I'm really not that well versed in VBA so I am mostly winging it.

OK. Open the macros window and change the code as below in Sheet2(Test)

Please Login or Register  to view this content.

Try the quiz again