I have created a form which has several cells (eg C3, C4, C5)
that have all LIST validation, where the "error alert" is set to
"information"
in order to allow entries that are not in the lists.
These validations work fine; but I would like to add a further condition
to these cells that would inhibit input,
in the event that another specific "key" cell (eg. A2) is blank,
as well as producing a message informing the user what remedial action to
take.
I'm afraid that I am at a bit of a loss as to how to proceed.