Data validation - restricting data

[Jen]

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

 

[Max]

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

 

[Jen]

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

 

[Max]

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

---