thedeadzeds
New member
- Joined
- Oct 25, 2011
- Messages
- 37
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
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.
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.