Data Validation

[jitendra]

In a sheet I have made data validation for a range so if I am entering wrong data for that range then error message is showing but it is allowing to enter wrong data so I want to make it as blank if the user want to proceed with wrong data. How to make it anyone can help me.

 

[CWatts]

Under your data valudation on the error alert tab, make sure it's set as "Stop" which will prevent the entry of the invalid data.

 

[jitendra]

Thanks a lot now it is working Properly