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     www.energyefficientbuild.com.   Mar-07-2015

question by Par Stalberg:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/yl4MSOmOgVE
Conditional Formatting formula for checking one cell in each column

Hi, 

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.  

=F2=$F$20

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?

https://docs.google.com/spreadsheets/d/1TcVVVqNULkiYXgK3M9D3xPK62VOYCbEECGDzYyxGHA8/edit?usp=sharing

Best regards 

Pär

----------------------------------------------------------------------------------------------------------------------------------------