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