title: Conditional Formatting if any cell in row contains text
body: <p>I have this formula which adds a border to a row if a certain cell in that row contains any text:</p>
  
  <pre><code>=$C5&lt;&gt;""
  </code></pre>
  
  <p>I want to change the formula to not just look at column C, but at the entire row in the table (which is A:I), i.e. if any text exists at all in that row, it must apply the formatting.</p>
  
  <p>Can't seem to get it right.</p>