title: Conditional Formatting in cell A1 based on value in cell N1
body: <pre><code>   A          N
  1  My Test    0
  </code></pre>
  
  <p>How can I make MyTest a red font if the value in cell N = 0? I explored the conditional formatting but it doesn't seem it allows me to set the condition on the value of a different cell other than itself..</p>