title: VBA Validate that if one cell in a range has a value, all cells should have a value
body: <p>I have a spreadsheet where users will be entering data in columns A through D. I want to identify in a message box any rows (i) where the range (Ai:Di) is not either completely blank or completely populated. The total range that users can populate is A2:D501.</p>
  
  <p>If no rows are identified, the macro should continue to the next piece of code that I've already written, which then proceeds to save the workbook. </p>
  
  <p>One twist - column C is prepopulated with =IF(A2&lt;>"",TODAY(),""). So, C will never truly be blank. The macro would need to consider the above formula as blank so that if a row only has that formula in column C it won't count it.</p>
  
  <p>Thanks for your help, I'm new to this!</p>