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

[joelexcel]

[TABLE="width: 266"]
<tbody>[TR]
[TD]Column A
(Date Ready)[/TD]
[TD]Column B (Done?)[/TD]
[/TR]
[TR]
[TD]28/08/2015[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]28/08/2015[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]28/08/2015[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]28/08/2015[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]30/08/2015[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]30/08/2015[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]30/08/2015[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]


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...