CAUTION<\/cite><\/blockquote>\n\n\n\nCustom<\/h3>\n\n\n\n
Custom validation is more complicated than other types of validation. Here, you can insert a formula with the specific parameters.<\/p>\n\n\n\n
At the bottom of the window, you will find the checkbox called Apply this changes to all other cells with the same settings<\/strong>. It means that if you click the cell and select this option, Excel will check in a worksheet (not a workbook) whether there are other cells with the same validation parameters. If so, all these cells will be selected and the changes applied.<\/p>\n\n\n\nInput Message<\/h2>\n\n\n\n
Here, you can set a pop-up window with a title and input message. Now, when you click the cell, a window with an entered message will appear.<\/p>\n\n\n\n
Error Alert<\/h2>\n\n\n\nStop<\/h3>\n\n\n\n
Excel displays an error message with the Retry<\/strong> and Cancel<\/strong> buttons. If you select the Retry<\/strong> button you’ll get a chance to re-enter the value. If you choose the Cancel<\/strong> button, the value will be restored to the one that was previously entered.<\/p>\n\n\n\nWarning<\/h3>\n\n\n\n
In this case, Excel displays a warning message. There are three options available: Yes, No<\/strong> and Cancel.<\/strong> If you choose Yes<\/strong>, Excel will enter the value that doesn\u2019t meet the conditions. If you click No<\/strong>, Excel will let you change the data. If you click Cancel<\/strong> then the data will be restored to the previous value.<\/p>\n\n\n\nInformation<\/h3>\n\n\n\n
When information window appears, you can click OK<\/strong> to accept the value or Cancel<\/strong> to return to the previous state.<\/p>\n\n\n\n\nExcel checks the value only after you create the validation rule. If you apply validation to the cells that already contain values, Excel will not complain, even if those values are incompatible with the rule.<\/p>\nCAUTION<\/cite><\/blockquote>\n\n\n\nRemoving validation<\/h2>\n\n\n\n
If you want to remove the validation from the cells, first select these cells, then click the Clear All<\/strong> button in the lower left corner of the Settings<\/strong> tab. Click OK<\/strong> to confirm.<\/p>\n\n\n\n