Validation can work for you.go to DATAValidation in excel 2003. you can even
give your own error message. but validation has its limit.

"Neale" wrote:

How do I make cells mandatory for a user to enter information and if the cell
is left blank the user should be prompted with a warning of the invalid entry