title: Conditional formatting depending on data from a column
body: <p>I'd like to create a rule that writes <code>"100%"</code> in column A whenever I write <code>"end"</code> in column B.
  So it would be something like this:</p>
  
  <pre><code>[]     X
  100%   end
  []     Y
  </code></pre>
  
  <p>The brackets represent an empty cell. </p>
  
  <p>I've tried:</p>
  
  <pre><code>IF(B1:B3="end",100%,"")
  </code></pre>
  
  <p>but I would like to leave the cells on column A empty, with no data or formulas, if the respective cell in column B doesn't contain "end". </p>
  
  <p>So I've thought about adding a new rule with conditional formatting but it's not working. Any solutions?</p>