title: excel vba code to replace empty cell with text based on adjacent cells number range
body: <p>Please help me, I'm frustrated with excel. Probably because I'm not that good with it. I've been tasked with the following. Take all blank cells in column c, reference the value in the adjacent cell in column b, and then print a statement in the cell.</p>
  
  <p>I tried this function to no avail.</p>
  
  <p>=IF(AND(C3 = "", 0 &lt; B3 &lt; 5000), "Order More", "Don't Order")</p>
  
  <p>I got a circular error. So I thought I must need to use VBA.</p>
  
  <p>Here are the snippets of code I have so far:</p>
  
  <pre><code>Worksheets("Sheet1").Activate
  
  For Each rw In Sheet1.Rows
  If rw.Columns("C") = "" and range.rw.Columns("B")
  </code></pre>
  
  <p>I'm not sure how to make it all work. I don't even know if that's correct. I've been trying to use the internet to help but it's just more confusing.</p>