Is it possible to ignore warning from Data validation while Criteria list from a range?

I have set a data validation as a list from a range but when I enter a text that does not match the list, I am getting a red warning in the cell.

My question is: How to use both methods with ignoring the red warning? Which is available in range list + which is not available in range list.

Hey @thingsveera I see you’ve asked this in the Javascript forum, but it looks like you’re using Excel…

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.