Error message when cell left blank

[Nated93]

Hi Community,

I'm producing a template for auditing purposes and is going to be provided to outsourced companies to complete the task.

I'd like to know if there is a data validation or macro that wont allow the auditor to leave a cell blank when he clicks on it because in the past we have had a very bad experences with a lot of blank or n/a information. Thus i have made data validation lists and unchecked "ignore blank", but i want to get that extra step.

Range is from Coloums A-L.

Thanks in advance.

Regards,


Nathan