title: Conditionally format column A if cell row contains "z"
body: <p>I want to highlight cells in column A (using the conditional formatting tool) if the cell's corresponding row contains the letter <code>z</code> anywhere within that row.  I want to do this so I can sort data to the top if it is highlighted in column A.</p>
  
  <p>I'm using the formula:</p>
  
  <pre><code>=COUNTIF($A1:$AA1,"*z*") 
  </code></pre>
  
  <p>But I don't want to highlight the entire row, just the corresponding cell in column A for that row.  </p>
  
  <p>What is the formula to do this?</p>