title: VBA to check for blank cells in columns based on value in another column
body: <p>Given</p>
  
  <pre><code>O    1    2    3   A
  A    4    5    6   B
  B    7    8    9   D
       O             3
       C            15
       T            18
  </code></pre>
  
  <p>I'm looking for VBA code to validate that when column A contains a value that the remaining columns also contain values and when it doesn't contain a value, that columns 2 &amp; 5 also contain values but 3 &amp; 4 don't.</p>
  
  <p>I've simplified the example, in a real sheet there will be many more columns and rows to check.</p>
  
  <p>I've considered COUNTIF and INDEX/MATCH and array forumlas but from my understanding these all work on single columns at a time.</p>
  
  <p>I want to do something like WHEN A1:An&lt;>"" THEN COUNTBLANK(B:E) ELSE COUNTA (C:D)</p>
  
  <p>Is the best way to use autofilter using blanks in A and then countblank and then a second autofilter for values in A.</p>
  
  <p>Thanks</p>