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

[NC]

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

 

[Rob van Gelder]

A previous post by Debra Dalgleish
http://groups.google.co.nz/groups?hl=en&lr=&[email protected]

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

 

[NC]

thanks rob

it works fine

regards
NC