Create the following validation roles: A custom format of "CV"#### has been applied to the stock numbers. Create a validation rule for the Stock No. column that ensures all new entries are four characters in length. (With a custom number format, it is not necessary to include the characters between the quotation marks in the text length.) Add this input message to the column: Enter the last four digits of the stock number. Use the default error alert options. Create drop down list for the Genre column with the entries provided.Do not enter an input message, and use the default error alert options.
Solved by F. F. in 22 mins