Set Up Data Validation Rules

Explain how to set up an Excel data validation rule for the range [Specify cell range, e.g., C2:C100] to ensure that users can only [Describe the restriction, e.g., 'enter a date between 1/1/2024 and 12/31/2025', 'select a value from a dropdown list sourced from Sheet3!B1:B10', 'enter text that is exactly 5 characters long', 'enter whole numbers greater than 0']. Include steps for setting an input message and an error alert.