Maybe you could have an adjacent cell with a formula like:
=if(a1<"","","Please Fill In A1!")
format in nice big red letters.
And if you have any important calculations, you could add a check to make sure
that the cell is completed before you show the results:
=if(a1="","Not until you fill in A1",yourcalculationhere)
Lisa wrote:
I need to set up a mandatory field in an Excel Template, can anyone help?
--
Dave Peterson
|