Using data validation I have put a drop down list of codes ranging from 200
to 900 in column E and a drop down list of client names in column F.

How do I make it so someone who chooses a code less then 700 from the list
has to choose a client from the list in column F?

Thanks in advance
Jenni

Maybe a simple alert message in adjacent col G might suffice?
Something like this in G2, with G2 bolded, then copied down:
=IF(AND(E2>=200,E2<700),"<<Choose client","")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jen" wrote:
> Using data validation I have put a drop down list of codes ranging from 200
> to 900 in column E and a drop down list of client names in column F.
>
> How do I make it so someone who chooses a code less then 700 from the list
> has to choose a client from the list in column F?
>
> Thanks in advance
> Jenni

Thanks! But can i still enter data into the G column?

"Max" wrote:

> Maybe a simple alert message in adjacent col G might suffice?
> Something like this in G2, with G2 bolded, then copied down:
> =IF(AND(E2>=200,E2<700),"<<Choose client","")
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Jen" wrote:
> > Using data validation I have put a drop down list of codes ranging from 200
> > to 900 in column E and a drop down list of client names in column F.
> >
> > How do I make it so someone who chooses a code less then 700 from the list
> > has to choose a client from the list in column F?
> >
> > Thanks in advance
> > Jenni

"Jen" wrote
> Thanks! But can i still enter data into the G column?

No, a cell can contain only a formula or a manually entered value at any one
time.
You could always use another adjacent col H??
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---