ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Validation (https://www.excelbanter.com/excel-discussion-misc-queries/213814-data-validation.html)

Data Validation

Can I use Data Validation to stop me a entering anything in say cell B2, if
cell A2 is blank?

Max

Data Validation

Select B2, apply data validation:
Allow: Custom
Formula: =A2<""
Uncheck "Ignore blank" OK
Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"nc" wrote:
Can I use Data Validation to stop me a entering anything in say cell B2, if
cell A2 is blank?

All times are GMT +1. The time now is 07:06 PM.