Data Validation Rules Generator

I need to set up data validation rules for my spreadsheet:

**Cell/Range to Validate:**
- Range: [e.g., C2:C1000]
- Purpose of this column: [what data should go here]

**Validation Type Needed:**
- [ ] Dropdown list from range or values
- [ ] Number within range (min/max)
- [ ] Date within range
- [ ] Text length limits
- [ ] Custom formula validation
- [ ] Dependent dropdown (cascading)

**Validation Details:**
- Allowed values or range: [list values or min/max]
- Allow blank cells: [Yes/No]
- Show input message: [Yes/No - what message?]
- Show error alert: [Yes/No - what type: Stop/Warning/Information]

**Special Requirements:**
- Validation based on another cell: [Yes/No - explain]
- Prevent duplicates: [Yes/No]
- Case-sensitive validation: [Yes/No]

Please provide:
1. Step-by-step data validation setup
2. Custom validation formulas if needed
3. Input message text suggestions
4. Error message text suggestions
5. Tips for handling validation with copy/paste