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

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

=IF(A1="","",IF(A1>400,"",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

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(A1>400,"",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