Conditional Formatting - Grading

[thumbyyy]

Hi,

I'm trying to grade quines and need some help with conditional formatting. Is there a way to do conditional formatting for all answers to match the key that is in the top row? I can set the conditional column by column, but I have a more than 100 columns, and wondering if there's a faster way?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Answer Key[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]T[/TD]
[TD]B[/TD]
[TD]D[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BOB[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]F[/TD]
[TD]B[/TD]
[TD]D[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]JANE[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]T[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]T[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]B[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]MARY[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]F[/TD]
[TD]B[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]


Thank you in advance!

 

[Eric W]

Sure. In this example, I had columns B:J with the answers, adjust as needed. The "B" in the formula refers to the first column in your selection.

Select your columns, B:J. Then click Conditional Formatting > New Rule > Use a formula > and enter:

=AND(B1<>"",ROW()>1,B1=B$1)

and select your fill color. Let me know how this works.

 

[thumbyyy]

That worked! Thank you so much! :D