One thiing I discovered. If the user hits cancel, the box will go away and
they can move on without entering anything when they select requirements not
met. They can also move on if they arrow past I8 or even tab past it. Is
there away to prevent this?

Thanks!

"Bob Phillips" wrote:

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