What do you want to happen if some or all of those cells are not filled in?
A formula in some cell can only return a value and only to that cell. It
cannot produce or create any action to entice or force the user to fill in
those cells. That would require VBA.
A small VBA macro can be added to your file that would check for entries
in those cells when an attempt is made to save or close the file. That same
macro can display a message box telling the user whatever you want. That
same macro can also cancel the save/close command if the proper conditions
are not met. Post back and provide more info about what you want to happen
and when. HTH Otto

"kcdonaldson" wrote in message
...
I am trying to set up a department checklist that has to be filled out
before
the end of their shift. I would like to create a formula that would verify
that certain cells have a value before the workbook closes. Can anyone
help
me with this one?