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
|