ࡱ>   AB=\508X"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Tahoma1 Arial1Arial                + ) , *      x@ @ + 83ffff̙̙3f3fff3f3f33333f33333Sheet1O.Some examples of data validation in WriteExcelEnter values in this column Sample DataIntegers List dataopenhighcloseFormula!Enter an integer between 1 and 10EEnter an integer that is not between 1 and 10 (using cell references)Enter an integer greater than 0Enter an integer less than 10#Enter a decimal between 0.1 and 0.5$Select a value from a drop down list9Select a value from a drop down list (using a cell range),Enter a date between 1/1/2008 and 12/12/2008#Enter a time between 6:00 and 12:00'Enter a string longer than 3 characters:Enter a value if the following is true "=AND(F5=50,G5=60)"+Displays a message when you select the cellCDisplay a custom error message when integer isn't between 1 and 100IDisplay a custom information message when integer isn't between 1 and 100 >  A*+%&?'?(?)?"dXX??U} @} } @    ?$@     ,D2 D< B$I@N@              >@,  0DD)L)\ 8  ? ? 8 openhighclose /  %, r8  ? ?)L< D2 D< B$L Enter an integer:between 1 and 100d Enter an integer:Input value is not valid!between 1 and 100)It should be an integer between 1 and 100d! Enter an integer:Input value is not valid!between 1 and 100)It should be an integer between 1 and 100d Root EntryWorkbook