title: Google Sheets Conditional Formatting: if cell A is full, and this cell is empty
body: <p>These should have been enough, but none of them have worked nor do any of their descriptions give an understanding of how they are supposed to work.</p>
  <ul>
  <li><p><a href="https://stackoverflow.com/questions/37513419/google-sheets-conditional-formatting-custom-formula-if-current-cell-is-empty-b">Google Sheets Conditional formatting custom formula: if current cell is empty, but other cell is not</a></p>
  </li>
  <li><p><a href="https://stackoverflow.com/questions/40899166/google-spreadsheet-conditional-formatting-based-on-empty-cell-with-spaces">Google Spreadsheet conditional formatting based on empty cell with spaces</a></p>
  </li>
  <li><p><a href="https://webapps.stackexchange.com/questions/85245/apply-conditional-formatting-if-other-cell-is-not-empty">https://webapps.stackexchange.com/questions/85245/apply-conditional-formatting-if-other-cell-is-not-empty</a></p>
  </li>
  <li><p><a href="https://support.google.com/docs/answer/3093290?hl=en" rel="nofollow noreferrer">https://support.google.com/docs/answer/3093290?hl=en</a></p>
  </li>
  </ul>
  <p>Here's the logic in code form:</p>
  <pre><code>const row = [&quot;Some Name&quot;, &quot;A value&quot;, null, null, &quot;Another Value&quot;];
  
  function conditionMet(row: string[], column: index) {
    return row[0] &amp;&amp; !row[column]
  }
  </code></pre>
  <p>Here's how I think it should be formatted:</p>
  <pre><code>=AND(NOT(ISBLANK(A)), ISBLANK(THIS))
  </code></pre>
  <p>Here's my best translation of the above based off the examples I've seen:</p>
  <pre><code>=AND(NOT(ISBLANK(A:1)), ISBLANK(A:1))
  </code></pre>
  <p>This isn't working.  I can't seem to find a &quot;THIS&quot; argument.  I also don't understand why every example includes a row number.  There's a fundamental gap in knowledge here that I'm sure is very obvious once you know it, but I haven't seen it specified yet.</p>
  <p>Edit: example included</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-css lang-css prettyprint-override"><code>td {
   border: solid black;
   border-width: 1px 1px 0px 0px;
  }
  
  table {
    border-spacing: 0px;
    border: solid black;
    border-width: 0px 0px 1px 1px;
  }
  
  td[r] {
    background: red;
  }</code></pre>
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;table&gt;
  &lt;tr&gt;
    &lt;td&gt;A&lt;/td&gt;
    &lt;td&gt;B&lt;/td&gt;
    &lt;td&gt;C&lt;/td&gt;
  &lt;tr&gt;
  &lt;tr&gt;
    &lt;td&gt;A&lt;/td&gt;
    &lt;td r&gt;&lt;/td&gt;
    &lt;td&gt;C&lt;/td&gt;
  &lt;tr&gt;
  &lt;tr&gt;
    &lt;td&gt;A&lt;/td&gt;
    &lt;td r&gt;&lt;/td&gt;
    &lt;td r&gt;&lt;/td&gt;
  &lt;tr&gt;
  &lt;tr&gt;
    &lt;td&gt;A&lt;/td&gt;
    &lt;td&gt;B&lt;/td&gt;
    &lt;td r&gt;&lt;/td&gt;
  &lt;tr&gt;
  &lt;/table&gt;</code></pre>
  </div>
  </div>
  </p>