Use Data Validation, Custom with a formula of =OR(H8<"Requirements not
met",LEN(I8)0), and uncheck Ignore blank.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CRVDiva" wrote in message
...
Please help!
I have a Pulldown menu in H8 with these choices: "Click Here to Rate",
"Requirements not met", "Requirements Met"

I need a formula or function statement that for this:
In H8 if "Requirements not met" is chosen, then I8 can't be left blank
(must
contain an comment);
If "Click Here to Rate" or "Requirements Met" is chosen, then I8 can be
left
empty.

I want the formula to require that comments have to be entered in I8 if H8
reads "Requirements not met".

Thanks