Basic data validation question

[Bingo Accent]

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.

 

[ed]

You could use some VBA to accomplish this.

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

 

[KC Rippstein]

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

 

[Ragdyer]

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)

 

[Bingo Accent]

I knew it was easy!

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