I can't believe that I can't figure this out for myself, but...

I want to use Data Validation to only allow entry to a cell, if the
content of another cell is a specific text.

i.e. Cell E5 has a status of 'Open' or 'Closed' (data entry
validated). Cell F5 shows 'Date Closed'.

I want to prevent someone entering a date in the 'Date Closed' cell,
if E5 shows 'Open'.

I've tried using Data Validation>Custom and entering variations on
=IF(E5="Closed"), but I'm getting nowhere.

Please help!

Thanks.

You could use some VBA to accomplish this.

Regards,
Eddie
http://www.HelpExcel.com

The easiest way to accomplish this is to follow Debra Dalgleish's
instructions here:
http://www.contextures.com/xlDataVal02.html
She has some links at the top of that page to other ways of doing it, but
the one presented on that page is the cleanest.
-KC

"Bingo Accent" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I can't believe that I can't figure this out for myself, but...
>
> I want to use Data Validation to only allow entry to a cell, if the
> content of another cell is a specific text.
>
> i.e. Cell E5 has a status of 'Open' or 'Closed' (data entry
> validated). Cell F5 shows 'Date Closed'.
>
> I want to prevent someone entering a date in the 'Date Closed' cell,
> if E5 shows 'Open'.
>
> I've tried using Data Validation>Custom and entering variations on
> =IF(E5="Closed"), but I'm getting nowhere.
>
> Please help!
>
> Thanks.
>

This seems to work if "Date Closed" is entered in E5 while F5 is either
blank or contains "closed":

Click in E5, and <Data> <Validation> <Custom>, and enter:
=AND(E5="Closed",F5>0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bingo Accent" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I can't believe that I can't figure this out for myself, but...
>
> I want to use Data Validation to only allow entry to a cell, if the
> content of another cell is a specific text.
>
> i.e. Cell E5 has a status of 'Open' or 'Closed' (data entry
> validated). Cell F5 shows 'Date Closed'.
>
> I want to prevent someone entering a date in the 'Date Closed' cell,
> if E5 shows 'Open'.
>
> I've tried using Data Validation>Custom and entering variations on
> =IF(E5="Closed"), but I'm getting nowhere.
>
> Please help!
>
> Thanks.
>

I knew it was easy!

A colleague came up with =E5="Closed" and it works.