How do you create a validation rule in excel?
- 1 Answers
- 725 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How do I create a scenario summary report in excel 2016?
What is the best font for excel spreadsheet?
What functions are used in excel?
How you can add a new excel worksheet?
What are the useful functions in microsoft excel?
What is the shortcut key to increase the font size in excel?
What are the 5 functions in excel?
What is a waterfall chart in excel?
How do I format a formula in excel?
How do I delete specific words in excel?
What does it mean to concatenate in excel?
How can I save a chart as a gif file?
MS Excel Microsoft 
