Require entry to multiple columns based on other column's values for big amount of records

I have a spreadsheet for some schools to enter their student data and there are a few required fields. Column A is for students' first names, column B is for students' last names, column C is for student status (ft vs. pt), column D is for major, and column E is for gender. I want to make sure that if first name and last name are entered in a row, the information of student status, major, and gender will be also be provided. The amount of students in a given school could be up to several hundreds, so I can't really write some codes to require answers for one student record and repeat it several hundred times. Can someone please help me with some codes that require answers for all the student records if first name and last name are entered to a row of the student records?

Thank you very much!

Hopefully I attached it successfully.

If you go to the "Worksheet for Schs to Fill Out" tab, you will see a worksheet with only column titles in it. This is what I am going to send to schools to fill out. Status (FT or PT), Major, and Gender are required fields. Without requiring mandatory entry in Excel, I could get some data from a school like the one in the "Sample School Response" tab. As highlighted there, some required information is missing. Since I need all the fields to be filled for all the student records, I will need some codes to prevent a school from saving the spreadsheet without all the required cells filled out. What I specifically want is that as long as there is a name in a row (row 2 to row 6 for this sample school), the system will show the message. The desired result is to get some data like the one shown in the "Desired Response" tab. Since a school could have up to a few hundreds of students,I don't want to write some codes for one student record and repeat it for several hundred times. Is there a way to write some codes for all the student records at once?

Thank you very much!

Hopefully I attached it successfully.

If you go to the "Worksheet for Schs to Fill Out" tab, you will see a worksheet with only column titles in it. This is what I am going to send to schools to fill out. Status (FT or PT), Major, and Gender are required fields. Without requiring mandatory entry in Excel, I could get some data from a school like the one in the "Sample School Response" tab. As highlighted there, some required information is missing. Since I need all the fields to be filled for all the student records, I will need some codes to prevent a school from saving the spreadsheet without all the required cells filled out. What I specifically want is that as long as there is a name in a row (row 2 to row 6 for this sample school), the system will show the message. The desired result is to get some data like the one shown in the "Desired Response" tab. Since a school could have up to a few hundreds of students,I don't want to write some codes for one student record and repeat it for several hundred times. Is there a way to write some codes for all the student records at once?

Thank you very much!

I don't know why, but the codes worked after I tried so many times. I have no idea why.