Sep 12 2021 07:56 AM
Sep 12 2021 09:02 AM
Highlight the cell in question and go to Data -> Data Review.
There you can go to the "Error Message" tab under "Type" instead of "Stop" select "Information" or "Warning".
If you see an error message above at "if invalid value is entered "remove the checkmark, you can enter any value without an error message.
More infos in this Link: More on data validation
Hope I was able to help you with this information / links.
What the answer useful? Mark them as helpful!
So you help all forum participants.