Hi @Muhammad Asif ,
In Excel you can try this method, select the Range you want to create the Data Validation- from Allow list select Custom and enter the formula:
Hope it's helpful.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.