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.
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.