Pop Up Box to force users to enter the correct information.

Hello All,

I am sorry for asking this question and hope I am saying it correctly.

I have a store with 3 registers. I have created an excel to help manage the money on a shift by shift basis. However everyone is not filling it out properly and things are going in the wrong areas etc. I was wondering if anyone knows of a way to make excel pop up with a question that says " What is the amount of cash you have on lobby register" and it would have a place to enter it. and so one. For each field. Then when done they just hit print and be on there mary way.

I would like to make it easy for them as I have been using this for a year and I spend 30 minutes every morning redoing the sheets from the other day.

Any help or pointers would be greatly appreciated.

Well a macro would do it but I'm not into macros so I played with Conditional Formatting.

This shows all the cells are 'black' and the ones requiring data are 'yellow'. Only after data has been put into the 'yellow' cells will the cells under them be normal.

Anyway, have a look.

Register Close out1.xlsx

Cheers