Conditional data entry, pending another cell (same row, different column) being 'Yes' or 'No'

[joelexcel]

Column A (Date Ready)	Column B (Done?)
28/08/2015	Yes
28/08/2015	Yes
28/08/2015	Yes
28/08/2015	Yes
	No
	No
30/08/2015	Yes
30/08/2015	Yes
30/08/2015	Yes

<tbody>
</tbody>

Default value is a 'No' - however after a date is populated to Column A, Column B can then be made a 'Yes'. Can't be an 'if' statement as it's not necessarily 'Done' straight away. Formula rule on Data validation maybe?


Kind regards
Joel

 

[Chrisdontm]

Default value is a 'No' - however after a date is populated to Column A, Column B can then be made a 'Yes'. Can't be an 'if' statement as it's not necessarily 'Done' straight away. Formula rule on Data validation maybe?
Kind regards
Joel[/QUOTE]
↓
According to your first statement;
Default value is a 'No' - however after a date is populated to Column A, Column B can then be made a 'Yes'.
This would be your formula for Cell B2;
=IF(A2<>"","Yes","No")
↑
I know, that is an IF statement...
About your second statement;
Can't be an 'if' statement as it's not necessarily 'Done' straight away. Formula rule on Data validation maybe?
If you want a " No " there when there is nothing there, but you don't want a " Yes " right away, What do you want in the Cell all the time then...?

A formula in Data Validation will be just like the IF statement...

I suppose I am asking you to clarify your desires, it just seems like something is missing...