In the screen shot below, there is a warning on cell C2, because two items are in the cell.
If you’re using data validation in a named Excel table, invalid data might be flagged by Excel’s Error Checking Rules, even if you turned off error alerts, or set the Style to Warning or Information. On the Error Alert tab, remove the check mark from “Show error alert after invalid data is entered” In some cases, you might want to turn off the data validation error alerts completely, like I do when allowing multiple selections from a drop down list. When I enter an item that isn’t in the list, the customized message appears, with a Warning icon, and different buttons. In this example, I selected Warning style, and entered a customized message. Instead of leaving the default settings for data validation errors, you can go to the Error Alert tab in the data validation dialog box, and customize them.Ĭhoose one of the Styles, and enter a Title and Error message that will give people details on what went wrong. You will have to clear the cell if you want to use the drop down arrow.