Select the range C$6$:C$8$ in the Friday worksheet, create a validation rule to allow whole numbers less than or equal to $=$B$6.$ Enter the input message title Seats Sold and the input message Enter the number of seats sold. $($including the period$).$ Use the Stop alert with the error alert title Invalid Number and the error alert message The number of seats sold cannot exceed the total seats in the section. $($including the period$).$ Test the data validation by attempting to enter $360$ in cell C$7$ and then cancel the change. Copy the range C$6$:C$8$ in the Friday worksheet. Select the range C$11$:C$13.$ Use the Paste Special Validation to copy the validation settings. Select the range C$16$:C$18$ and paste the validation again.