whole row mandatory and Prompt Answers from previous cell

[babiijodiix]

Hi

I am new to excel and having a mess around with creating mandatory cells. My worksheet is basically 15 columns across (A-0) and due to me having hidden layers above, for some rows to be auto filled, the first row where the data entry will begin is on number 27.

I have managed to create a mandatory message before saving but only on one cell at a time. I basically want to have a message pop up before saving if any of the columns, B, E, F, G, I, J, M, and O have no information in them. For example - if Column B was empty it would prompt a message before saving saying "Postcode Required" and if O is empty, then it would say "Name Required". Each column would have its own error message.


Once I have this sorted, the next thing I want to work out is if a certain row (G) has the option "Unhealthy" (created in a drop down list using data validation), than row H needs to have reason why.


Hope anybody can help

Thanks

 

[sijpie]

This is easy to achieve, but in order to get the response correct, Just to check:
you want to check if the user has left some cells in a row empty. Say that the user has entered something in cell A27, then it needs to check if all the other cells in that row (columns B,E etc as per your post) have been filled out. But not for the other empty rows 28 and downwards. So only if some data has been entered in a row.

if so, which columns is the user allowed to enter data in? Only B,E, F, G, I, J, M, and O , or also other columns?