Here's how to create ... emerge when text or data that’s not found in the list is entered. Enter a custom title and a message. Should the title or text fields be left empty, Excel will apply ...