title: How to use VBA to color and frame cells with value
body: <p>I'm trying to color and frame a column in data. There are blank rows inside. I only want to color the cells with value. The data position might change, so I want to use an input box to color and frame .</p>
  
  <p>The data will be like this. The select range would be column B.</p>
  
  <pre><code>1   A
  2   B
  3   
  4   A
  5   B
  6   
  7   A
  8   B
  9   
  10  A
  11  B
  12  
  13  A
  14  B
  15  
  16  A
  17  B
  18  
  19  A
  20  B
  21  
  22  A
  23  B
  </code></pre>