Answer Posted / Abhinav Kodesia
To create a custom validation rule in Excel, follow these steps:
1. Select the cell(s) where you want to apply the validation.
2. Click on 'Data' tab, then go to 'Data Validation'.
3. In the 'Data Validation' dialog box, click on 'Custom'.
4. Enter your custom formula in the ' Formula' field (e.g., `=ISNUMBER(SEARCH("*[0-9]*",A1))`).
5. Configure other settings as needed and specify error messages if required.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
