This from Excel Help on "validation".

In many worksheets that you create, users will enter data to get the desired
calculations and results. Ensuring valid data entry is an important task. You
may want to restrict data entry to a certain range of dates, limit choices by
using a list, or make sure that only positive whole numbers are entered.
Providing immediate help to instruct users and clear messages when invalid data
is entered is also essential to make the data entry experience go smoothly.

You can re-word it to your precise specifications.

For criteria see Help on "prevent invalid data entry"


Gord Dibben MS Excel MVP


On Mon, 12 Mar 2007 06:03:18 -0700, Rajeswari
wrote:

I want ageneral description of validation and the criteria for validation.
I am using office 2003 professional
The result i want should be inthe form of precise definition type.