kashifziatevta423
New Member
- Joined
- Sep 27, 2020
- Messages
- 4
- Office Version
- 2019
- Platform
- Windows
Thanks a lot for your response dear, but its not working for me. (excel version 2019)Say the cells you want to apply Data Validation (DV) to are A1:A10. First, name the range containing your Holidays & Sundays "Exclude" using Formula>Define Name. Then select A1:A10 and go to Data>Data Tools> Data Validation. Then select Custom and input this formula (see image below): =$A1<>Exclude and click OK.
View attachment 23160
You've not defined the named range "Exclude" properly. It not include the first cell with "Exclude" in it.Thanks a lot for your response dear, but its not working for me. (excel version 2019)
Please help
You are welcome - thanks for the reply.Dear Sir, its perfectly fine working. Million of thanks.