One problem with this is that it will give the message even when A2 has something in it.
How about:

=IF(AND(A1<"",A2=""),"<< Complete A2 !!","")
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Max" wrote in message
...
One way ..
In B2: =IF(LEN(A1)<0,"<< Complete A2 !!","")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeff" wrote:
Hi,

I like to know how do I set up in excel to setup a field to be a mandatory
field if the field beside it has data ?

For example: If A1 has data, A2 can not be a blank field and prompt error
message.