title: Conditional Formatting based on values of table
body: <p>I would like to turn black a cell if on the table any of the rows match this condition:</p>
  
  <p>Table : A1:G100<br>
  Cell to format J1</p>
  
  <p>Condition that I would like to to implement:</p>
  
  <pre><code>IF(AND(A1=0;OR(B1="bob";B1="jack")) 
  </code></pre>
  
  <p>turn the cell J1 black.</p>
  
  <p><img src="https://i.stack.imgur.com/TYBMR.png" alt="Example"></p>
  
  <p>I used the Excel conditional formatting function and I got the result applying the formula only to the first row of my table.
  How can I format the cell based on the repetition of the formula for each column of the table?</p>