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