Data Validation list in column G is Yes in column E and restrict entery if E is not Yes

[USAMax]

I know how to create a drop-down list and I know how to restrict access but can I do both?

I even went so far as to rename the named range to Yes and used Indirect to get the drop-down I wanted but the user can still enter other values when column E is blank.

How do I get column G to display a drop-down list when column E is Yes and prevent users from entering anything when column E is blank or No?

 

[USAMax]

Using Indirect I created another Named Range called No that is blank. Now how do I restrict the user from entering a value in column G when column E is blank?

 

[USAMax]

I came up with a work around. Because I am using SharePoint the workbook cannot have macros (a whole different conversation) but I added a module with one line to add a space in every cell then removed the module. Unless someone knows enough to clear the cell the data validation will not allow the user to enter a value.

Range(Cells(12, 5), Cells(3000, 5)) = " "