Mandatory Cells

Hi All,

I have been looking for a solution for this for a few hours now and I am getting nowhere with Google/Trial and Error so I am hoping someone more knowledgable can point me in the right direction.

I have a workbook being sent to multiple offices to gather information from the office manager, unfortunately they are frequently failing to complete all the required information and causing multiple emails back and forth to complete the form.

I am looking for a way to force the completion of columns B-H if there enter any value in column A. I have found solutions to similar issues online but have not been able to adapt any of them to work the way required.

For example if A2 contains a value then B2 - H2 should all contains values or the workbook should fail to close/save.

It is possible that multiple rows will be completed and as such need to also have mandatory cells. For example if Cells A2, A3, A4 all contain values then B2 - H4 should also contains values.

The entries in column A should be contiguous.

Can anyone advise if this is possible? has anyone come across a similar problem/solution?

Thanks

Rich