I've tried searching for a solution to my issue, as I'm sure there's information out there, but I can't seem to hit upon the proper query string to find what I want.
I am working on a workbook that consists of several tabs that contain the answers that students provided on quizzes. There is a column with the name of the quiz (there are three different quizzes per class, all stored on the same sheet) and then a column for each question from the quiz (3-5 questions per assessment).
TITLE | STUDENT | QUESTION1 | QUESTION2 | QUESTION3 | QUESTION4 | QUESTION5
I have another similar sheet that serves as a key, with the correct answers for each question.
What I would like to do is change the color of a cell if the answer is incorrect. So I would first need to check the Title column to see which row in the key contains the correct answers, then I would need to check the cell in that row that contains the answer, then change the color if the answer provided by the student doesn't match the cell containing the correct answer.
What is the most efficient way to accomplish this?
Bookmarks