Solved How to use conditional formula in data validation?

June 27, 2018 at 21:11:08
Specs: Windows 7
How to use data validation for "if Cell A1 >0 then Cell B1 can not be blank"?

means if user enter some number is cell A1 then cell be can not be blank. and if user keep cell A1 blank then Cell B1 can be blank. how to use Data validation tool for this?


See More: How to use conditional formula in data validation?

Reply ↓  Report •

#1
June 27, 2018 at 21:34:46
✔ Best Answer
1 - Select A1

2 - Open Data Validation Dialog Box

3 - Allow: Custom

4 - Formula: =B1<>""

5 - Very Important: Uncheck the Ignore Blank box

6 - Click "Error Alert" tab and enter an Error Message for users

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question