Dates with or without time portions are allowed as well as numbers equivalent to valid dates. When comparing against constraints, the cell value is used.
Only numbers are allowed. When comparing against constraints, the cell value is used.
Non-error values are allowed. When comparing against constraints, the length of the cell value's text equivalent is used.
Times are allowed are well as numbers equivalent to valid times without a date portion. When comparing against constraints, the cell value is used.
Only numbers are allowed and they cannot have a fractional part. When comparing against constraints, the cell value is used.
Determines what types of cell values are allowed and how the cell value is validated against the constraint(s).
See