Spreadsheet: 71370d1272035903-excel-2007-multiple-cell-dependant-data-validation-myexcelproblem
Sheet: Sheet2

 | Define |  |  | Application | 1 | Within.defined.Number.of.days
 | Application.Data |  | 1 | Application.Creation.Date |  | Within.defined.Number.of.future.days
 | Candidate.Data |  | 2 | Application.Creation.User |  | Within.defined.Period
 | Cost |  | 3 | Application.Last.Update.Date |  | Within.Date.Range
 | Job.Content.data |  | 4 | Application.Last.Update.User |  | Is.Null
 | Job.Workflow.History |  | 5 | Application.Shortlisted |  | Is.Not.Null
 | Referrals |  | 6 | Application.Status | 2 | [NAME] | 2 | Name 1
 | Selection.Process.History |  | 7 | Date.when.Status.changed.to.AutoClosed |  | Not.Equal.to |  | Name 2
 |  |  | 8 | Date.when.Status.changed.to.Cancelled |  | In |  | Name 3
 |  |  | 9 | Date.when.Status.changed.to.Closed | 3 | Within.defined.Number.of.days |  | Name 4
 |  |  | 10 | Date.when.Status.changed.to.Completed |  | Within.defined.Number.of.future.days | 4 | Room 1
 |  |  | 11 | Date.when.Status.changed.to.Hired |  | Within.defined.Period |  | Room 2
 |  |  | 12 | Date.when.Status.changed.to.In.Process |  | Within.Date.Range |  | Room 3
Domain | Application.Data |  | 13 | Date.when.Status.changed.to.Offer.Accepted |  | Is.Null |  | Room 4
Field | Application.Creation.User |  | 14 | Date.when.Status.changed.to.Offer.Declined |  | Is.Not.Null
Operator |  |  | 15 | Date.when.Status.changed.to.Offered | 4 | [NAME]
 |  |  | 16 | Date.when.Status.changed.to.Open |  | Not.Equal.to
 |  |  | 17 | Date.when.Status.changed.to.Rejected |  | In
 |  |  | 18 | Date.when.Status.changed.to.Withdrawn | 5 | Yes
 |  |  | 19 | Sourcing.Channel.Name |  | No
 |  |  | 20 | Sourcing.Channel.Type | 6 | [NAME]
 |  |  | 21 | Sourcing.Medium |  | Not.Equal.to
 |  |  |  |  |  | In
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 7 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 8 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 9 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 10 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 11 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 12 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 13 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 14 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 15 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 16 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 17 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 18 | Within.defined.Number.of.days
 |  |  |  |  |  | Within.defined.Number.of.future.days
 |  |  |  |  |  | Within.defined.Period
 |  |  |  |  |  | Within.Date.Range
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 19 | Not.Equal.to
 |  |  |  |  | 20 | [NAME]
 |  |  |  |  |  | Not.Equal.to
 |  |  |  |  |  | In
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null
 |  |  |  |  | 21 | [NAME]
 |  |  |  |  |  | Not.Equal.to
 |  |  |  |  |  | In
 |  |  |  |  |  | Is.Null
 |  |  |  |  |  | Is.Not.Null