View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NC NC is offline
external usenet poster
 
Posts: 7
Default 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