Using 360
Is it possible to create a pop up to appear on the screen showing not all cells that require a value have not been filled out?
I have this estimating tool, and the first tab called "Summary" is where the contractor choses the estimation criteria such as billing rates, crafts, specs, etc..etc.
Some cells are MANDATORY to be populated and to indicate these cells I made the cells red with instructions big and bold saying :ALL RED CELLS MYST BE POPULATED BEFORE SUBMITTING ESTIMATE
Well there is one group of cells they keep forgetting to populate, which is the estimate crew sizes for each craft. I keep reminding them they are forgetting to populate the crew size cells and they correct it for a day or two but go back to "forgetting"
So is there a way to make a pop up window show up basically saying "not all red cells are filled out" and also, maybe, preventing them from moving on to other tabs in the work book tab all red cells are populated?
There are 23 red cells that are mandatory to be filled out..they keep forgetting to fill in 5 of them.
Is it possible to create a pop up to appear on the screen showing not all cells that require a value have not been filled out?
I have this estimating tool, and the first tab called "Summary" is where the contractor choses the estimation criteria such as billing rates, crafts, specs, etc..etc.
Some cells are MANDATORY to be populated and to indicate these cells I made the cells red with instructions big and bold saying :ALL RED CELLS MYST BE POPULATED BEFORE SUBMITTING ESTIMATE
Well there is one group of cells they keep forgetting to populate, which is the estimate crew sizes for each craft. I keep reminding them they are forgetting to populate the crew size cells and they correct it for a day or two but go back to "forgetting"
So is there a way to make a pop up window show up basically saying "not all red cells are filled out" and also, maybe, preventing them from moving on to other tabs in the work book tab all red cells are populated?
There are 23 red cells that are mandatory to be filled out..they keep forgetting to fill in 5 of them.