View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jen Jen is offline
external usenet poster
 
Posts: 119
Default How do I restrict what is entered in the next cell?

Hi,
I have a list of codes from number 200 to 900. For all codes 400 and under a
clients name needs to be added in the next cell. For all codes over 400 there
does not need to be a client in the next cell. How can make it so when
someone enters the code 400 or under they have to enter a clients name in the
next cell?

Tx