data validation to restrict input in cell based on value of cell above that cell
 

Hi all,

i am creating a spread sheet in which users are supposed to enter data
in one column. i want to add validation in such a way that user will
not be able to enter data in the say cell "C1" if he has not entered
value in cell "B1"i.e if "B1" is blank
Can anybody plz help

Thanks in advance

Regards
NC

data validation to restrict input in cell based on value of cell above that cell
 

A previous post by Debra Dalgleish
http://groups.google.co.nz/groups?hl...r esXSPAM.com

Select cell A2
Choose DataValidation
Choose to Allow:Custom
In the Formula box, type: =A1<""
Remove the check mark from 'Ignore blank'
Click OK


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"NC" wrote in message
oups.com...
Hi all,

i am creating a spread sheet in which users are supposed to enter data
in one column. i want to add validation in such a way that user will
not be able to enter data in the say cell "C1" if he has not entered
value in cell "B1"i.e if "B1" is blank
Can anybody plz help

Thanks in advance

Regards
NC

data validation to restrict input in cell based on value of cell above that cell
 

thanks rob

it works fine

regards
NC