If you mean for Conditional Formatting then try:

=MAX(A1:A3)-MIN(A1:A3)2

If you mean to show an error message in a cell then try:

=IF(MAX(A1:A3)-MIN(A1:A3)2,"Too Big!","")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Khaledity" wrote in message
ups.com...
Hi,

I need your help to make a formula gives me alert when the difference
between 3 cells is more that 1 point!

For example: If A1=1, A2=2, and A3=3 then this is fine,
But if A1=1, A2=2, and A3=4 so I want to see an alarm on A3 when the
difference between A1, A2 & A3 is more than 1

Thanks in advance.

Khaledity