Custom Data Validation

Hello -

I have a worksheet that contains data validation dropdown lists in cells E4 to E7 (see attached). Here's what I need to happen:

When cell C4 = "Apple", cells E4 to E7 can equal any of the values shown in the dropdown list.
But when cell C4 = "Orange", cell E4 can equal any of the values shown in the dropdown list but cells E6 and E7 must resolve to N/A.

Thanks,

Grillman

C4 = apple

e4 (could be)= Y or N or N/A

but when C4 = Orange

e4 (could be)= Y or N
e5 must be N/A
e6 must be N/A