title: Conditional formatting coloring errors when comparing text values in column to top row
body: <p>I'm trying to make my Google spreadsheet (that is populated with textual responses from Google Forms) to color the background of the "wrong" cells red. I have the correct answer for each column at the very top in row 1. These are all alphabetical text, not numerical answers.</p>
  
  <p>IF the value is NOT EQUAL to the top of the column, that cell is colored. So the "<em>wrong</em>" response in the below example will be colored, as it isn't the same text as the top row:</p>
  
  <pre>
    ____ A ___  B  ___  C  ___  D  __
  1   <b>ans1     ans2   ans3      ans4</b>
  2   *wrong*  ans2   ans3      *wrong*
  3   ans1     ans2   *wrong*   ans4</pre>
  
  <p><em>Here's where I've come across a problem.</em> With help from <a href="https://stackoverflow.com/users/1373663/adaml">AdamL</a>, I used <code>=AND(LEN(F5),F5&lt;&gt;F$1)</code> on the range <strong>F5:CM</strong>, which did the job for three of my spreadsheets, but two of the spreadsheets are working up.</p>
  
  <p><strong>1)</strong> Cells with the value TRUE are being universally colored.<br>
  <strong>2)</strong> Column L colors cells with the correct target answer (from L1) of FALSE.<br>
  <strong>3)</strong> The rest of the cells (from all columns) show no coloring response to the "wrong" values (values that don't match the top), only coloring the cell if has the text "TRUE".</p>
  
  <p>Any ideas why this might be happening?</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1GNHfK-q_mjxH4FBHGhtRG26RB-x3UpUqGv00acpvgsI/edit?usp=sharing" rel="nofollow noreferrer">LINK</a> to the spreadsheet</p>