Make a column mandatory if data entered into row

[atrant]

Hi all,

First time poster so please let me know if you need any additional info!

I have a basic workbook (see image attached) where I want to ensure that if a user enters data into a cell in, for example, row 34 column A and B, they cannot close the workbook or save it without entering yes or no into 34C.
I also want this rule to continue on for each row every time some new data is entered.
If anyone can help I would really appreciate it!

Thank you!

Untitled1.png

[antoka05]

You could use this code (Press Alt+F11 to open vba editor, click on View menu and then in Project Explorer, select This Workbook and paste the code):

Please Login or Register  to view this content.

Regards,
Antonio

[atrant]

Thank you so much Antonio! That worked perfectly