Restrict Cells depending on input in another cell

[Dave350z]

Hi folks,
I have two cells, A1 = Yes/No and B1 = Date. I want to restrict someone inputting a date into B1 until A1 is marked as Yes... any ideas? I've tried data validation, but seem to be hitting a wall with it...

Cheers

[benishiryo]

hi Dave350z. select A1. go to Data -> Data Validation -> Allow: Custom-> Formula:
=A1="Yes"
Uncheck "Ignore Blank"

[Dave350z]

Perfect - Cheers! I knew it'd be an easy one