Use Data Validation with either a number <= 1 or a custom formula of

=A2<=1

No ding though.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Paul987" wrote in
message ...

I would like to create an Alert box that would pup up when a specific
event occurs. For instance if cell A2 1 , then a box would pop up,
and state "a2 1" and require acknowledgement. Maybe even ding until
click off. Is this possible? I would like to do it w/o VBA so it can
be more flexible and can be created easier by an end user. Any
advice?
TIA
Paul


--
Paul987
------------------------------------------------------------------------
Paul987's Profile:
http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=520206