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?