Data Validation - Disable cell based based on another cells entry (with pop up box)

[mhasham]

Hello Folks,

Question about 'Data Validation'...........I am attempting to disable cell H6 (which has a data validation list in it) based on an entry of a data validation list that resides in cell H5.

So If user selects a 0 in cell H5 then i would like to disable cell H6 (grey out box), is this possible since both cells have data validation in them?
- once cell H6 is disabled can a pop up message come up and once they click ok/accept on it they're directed to cell H7


NOTE: Users would like to be able to go back into file and update if necessary, so I cannot remove the data validation entirely. Only if 0 is selected then I would like to disbale the given cell


Any help would be appreciated, thanks.