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

How do I restrict what is entered in the next cell?
 

If the codes are entered in column A then in C1 enter:

=IF(A1="","",IF(A1400,"",IF(B1<"","","enter a name in column B")))
and copy down

This will expose a reminder that the client name has not been entered in
column B
--
Gary''s Student - gsnu200793


"Jen" wrote:

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

How do I restrict what is entered in the next cell?
 

Thanks for that, but I want to be able to enter information into C column
also.

"Gary''s Student" wrote:

If the codes are entered in column A then in C1 enter:

=IF(A1="","",IF(A1400,"",IF(B1<"","","enter a name in column B")))
and copy down

This will expose a reminder that the client name has not been entered in
column B
--
Gary''s Student - gsnu200793


"Jen" wrote:

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