Invalid values are allowed. The error dialog shown in Microsoft Excel displays an information icon and ok and cancel buttons. The ok button commits the value to the cell. The cancel button will cancel the edit and revert the cell back to the previous value it contained before the edit operation.

Invalid values are not allowed. The error dialog shown in Microsoft Excel displays an error icon and retry and cancel buttons. The retry button will put focus back in the cell and allow the user to try to enter a new value. The cancel button will cancel the edit and revert the cell back to the previous value it contained before the edit operation.

Invalid values are allowed. The error dialog shown in Microsoft Excel displays a warning icon, asks the user if they want to continue, and has yes, no and cancel buttons. The yes button commits the value to the cell. The no button will put focus back in the cell and allow the user to try to enter a new value. And the cancel button will cancel the edit and revert the cell back to the previous value it contained before the edit operation.