How to set an alarm when there is a difference between cells?

K

Khaledity

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
 
S

Sandy Mann

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

[email protected]
[email protected] with @tiscali.co.uk
 
Top