Saturday, March 7, 2015

yogi_Conditionally Format Entries In Cells B2 To H13 That Match Correct Answers As Shown In Cells B20 To H20

             Google Spreadsheet   Post  #1911
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-07-2015
question by Par Stalberg:!category-topic/docs/spreadsheets/yl4MSOmOgVE
Conditional Formatting formula for checking one cell in each column

I have a spreadsheet where I get the data from a form where people is filling in answers and id like to highlight the correct answers for ever column in the spreadsheet. 
Right now I have to make a conditional formatting for every column to make it work. You can see the formula below and in column F in the linked spreadsheet.  


So my question: How can I mark the range B2:H13 in conditional formatting and make every column check row 20 for the correct answer?

Best regards