title: Conditional cell disablement in Excel
body: <p>I'm using Excel 2007. I want the following behaviour:</p>
  
  <ul>
  <li>If cell A2 is empty or contains value "Create" then cell B2 is inactive and the user cannot enter a value.</li>
  <li>If cell A2 contains the value "Modify" or "Retire" then cell B2 is active and the user can enter a value.</li>
  </ul>
  
  <p>These behaviours need to be limited to their specific rows, so cell B3 needs to be unaffected by the value in cell A2. These behaviours need to be functional in rows 2 to 501.</p>
  
  <p>I guess that this will require some VBA</p>