title: Excel macro: how do I change all row heights, BUT if cell.value = bold make the cell height bigger?
body: <p>I'm working on a long list of data (Column B) that has been formatted using <strong>bold</strong> and indents. The bold cells contain the titles/category names and the indented cell values are the subcategories.</p>
  
  <p>The row heights are all over the place. It should have been 10.5 for everything, and the <strong>bold cells/rows</strong> 15. I can change everything to 10.5, but then I need to spend quite a bit of time scrolling through the list amending the bold row heights. I've used the format painter but it's a long list and I didn't want to spend so much time on this part of the process. And now I know that I'll need to do this to another 30 documents.</p>
  
  <p>Does anyone have a quicker way of doing this?  </p>