Only allowing someone to sign off on an excel checklist if every question has been answered?

[ExcelAccountant123]

Hi

I am creating a checklist that is in excel and our staff has to tick off every box.

At the end of the checklist, they have to sign off with there initials and a date.

Is there a way in Excel to have some kind of error message pop up or prevent someone from entering info into a box if it hasn't they haven't answered every previous question?

I was thinking this should be in the data validation area, but I cant find it.

Any help will be appreciated.

Thanks!

Also posted here Only allowing someone to sign off on an excel checklist if everything has been answered?

 

[Fluff]

Are you entering information into cells?
If so which cells & what are you putting into them?

 

[ExcelAccountant123]

Yes, the staff will be entering information into cells.

I have attached a simple image of what it could look like.

I would like the staff to not be able to enter their name unless they have answered every previous question.

 

[Fluff]

What will they be putting into those cells?

 

[ExcelAccountant123]

They should be entering Yes or No into the cells. I'm not sure if it should be very strict because some people may prefer to write "Y" instead of "Yes" for example.
Thanks

 

[Fluff]

Ok, for G21 use custom & this formula
=COUNTA(G6:G18)=7
For G22 use
=G21<>""
& deselect Ignore blank