View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Mandatory/Compulsory

EXCEL 2007

Data / Data Tools group / Data Validation / in here there are various
options available to you including custom messages.

If my comments have helped please hit Yes.

Thanks.

"Md.Siddique" wrote:

Hi Sir,
I need to put a formula for a cell as mandatory/compulsory it has to fill,
otherwise it will not go to the next cell. It has to display (customized)
error message.
Can anybody help me in this regard? I have Office 2000, 2003 & 2007. It has
to work in all versions.
Rgds,
Md.Siddique.