Hello - I've been working on this by myself all morning but I know there's an easier way. Hoping you can help!
I have a spreadsheet of multiple choice responses for an exam. The first row is the correct answer for each question (i.e. instructor's sheet), and each row has the corresponding responses for a student. I would like to highlight the cells where a student's answer does not match the instructor's answer. I have been able to do this for a single column (so that all the incorrect answers for that question turn red) using conditional formatting.
Is there any way to do this for the worksheet without doing it column by column? I have been using the drop down menu (conditional formatting) because I'm a complete noob on excel. Basically I just want any values in the worksheet to be red if they don't match the values in that column's first row.
Any help you can provide would be very appreciated!!!!!
Bookmarks