Is it possible to validate free text input in a cell and display in another cell if the input is accepted or not. For example, if I enter XXYYZZ in cell A1, is it possible to display in cell B2 "Verified" or "Not verified", for example? The input in XXYYZZ must be checked against a list. However, even if the input is not valid, the user should be allowed to continue, but simply receive a warning
