IF FUNCTION WITH DATA VALIDATION (ie, if C3 has data, F3 must be completed)

[thedeadzeds]

Hi guys,

I've got a basic spreadsheet (attached) with data validation and depending on what is input into a certain cell, I wanted a few different things to happen:

1. Column F from F3 to F300 must have some data input if column C has a date in it. ie, IF C3 has a date then F3 must be completed and so on C4 THEN F4 must be completed etc.
2. IF C3 has a date, either H3, I3 or J3 must be completed (but only one out of the 3) and so on down the list
3. IF H3, I3 or J3 is completed then K3 must be completed and so on down the list
4. IF K3 is completed, L3 automatically shows 'Yes'. If not, show No and so on down the list.

Hope this can be done,

Thanks in advance
Craig.Attachment 127003