Data validation - restricting data

  • Thread starter Thread starter Jen
  • Start date Start date
J

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

---
 
Back
Top