Specifying an error alert style and message

Data-> Validation-> Data Validation Dialog Box-> Error Alert Tab

Creating an input message

Data -> Validation -> Data Validation Dialog Box-> Input Message Tab

Specifying data types and acceptable values

Data -> Validation-> Data Validation Dialog Box -> Settings Tab