title: Conditional Formatting formula for each individual row?
body: <p>I'm trying to change the background color of all cells containing "@". I've finally found a formula that works:</p>
  
  <pre><code>COUNTIF(A3;".@.")&gt;0
  </code></pre>
  
  <p>Now I can't seem to figure out how to change this formula to affect each individual cell based on it's own value. For example, I want the formula to work in such a way that:</p>
  
  <ul>
  <li>Cell A3 is formatted if Cell A3 contains "@" </li>
  <li>Cell A4 is formatted if Cell A4 contains "@" </li>
  <li>Cell A5 is formatted if Cell A5 contains "@"</li>
  <li>etc.</li>
  </ul>
  
  <p>I know I've done this before in Excel, so I'm sure there's a way to do it.</p>