On Sep 28, 1:34*pm, Luke M wrote:
Well, it depends on what the final action is. Does the user click a button to
save the form somewhere, or do something? To the point, how will XL know the
difference between someone who is still working on the form, and someone who
is done?

A basic idea would be to use a COUNTA formula that checks all your required
cells. So, for one row
=IF(COUNTA(A2,B2,D2)=3,"Complete","Incomplete")
would be a type of basic check.

You could also include a similar formula in Data - Validation. For instance,
let's say you have a signature cell or something. You could make the
validation on that cell
=COUNTA(A2,B2,D2)=3

Now, the user will only be able to "sign" the cell once A2, B2, and D2 have
been filled in with something.

But again, to restress beginning point, the main thought to think on is how
is XL to know that someone is "done" and the data should be verified?

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Thanks Luke and Dave. I think I see a way around this - get the user
to check a check box when they think they're complete. At that stage
validate the form, and highlight non-conforming cells. Or something.

Edward