Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
from the data tab select data validation customize your settings according to your rules and the message you want to add as an alert or a forcing and stopping window etc...
I think you should go to Data tap then select Data Validation.
1- Select Data - column and row -
2- Choose the data list
3- Click on Data Validation Option
4- Select option - Data validation -
the best fit solution for this situation is Data Validation.
follow this steps:
hope this answer your question