title: If I have a 0 in column B, I want to set the row next to it in column A to be blank, how?
body: <p>I feel like the title summarizes it pretty well, but will try to explain further. As of right now I am using conditional formatting to hide the 0's in column B, but I have data in column A that I also want to hide if the 0 condition is true. For example:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Column A</th>
  <th>Column B</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Michael</td>
  <td>90</td>
  </tr>
  <tr>
  <td>Dave</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Mark</td>
  <td>24</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have a macro to sort the data from largest to smallest for columns A &amp; B, but then I would like to &quot;hide&quot; Dave from column A considering he has a 0 in the row next to his name. Like I said earlier, I have conditional formatting to hide all of the 0's in column B, but am struggling to find the correct way to hide the information in column A. Please let me know if you can help!</p>