Can I use Data Validation to stop me a entering anything in say cell B2, if cell A2 is blank?
N nc Dec 16, 2008 #1 Can I use Data Validation to stop me a entering anything in say cell B2, if cell A2 is blank?
M Max Dec 16, 2008 #2 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
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
