Data validation - restricting data
 

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

Data validation - restricting data
 

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

Data validation - restricting data
 

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

Data validation - restricting data
 

"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
---