Hello everybody. I created a spreadsheet that has dropdowns and cells for people to fill in information. My supervisor has now asked me to set it up so that the form won't print unless all necessary information is filled in. I figured the easiest way to do this is create a button for printing the form.

I selected the cells I want as the "button". Now here is problem, I would like the button to be greyed out until all the necessary cells are filled. How can I have the "button" able to be pressed, but only be active if all the cells contain information?

Any help on this would be greatly appreacited. Thank you in advance.