checking for values in a row

[[email protected]]

Hi,

I have the word "yes" in cells A2:A20. I want A1 to get flashed by
changing its value to say 'alert' the time any value in cell A2:A20
gets changed to anything other than "yes".

I tried if(A2:A20<>'yes',"alert") it doesnot work. it seems to check
only the value of the cell in A20.

Thanks in advance
Amag

[Rowan Drummond]

One way (and I am sure there will be others <g>):
=IF(COUNTIF(A2:A20,"yes")<19,"Alert","")

Regards
Rowan

[email protected] wrote:
> Hi,
>
> I have the word "yes" in cells A2:A20. I want A1 to get flashed by
> changing its value to say 'alert' the time any value in cell A2:A20
> gets changed to anything other than "yes".
>
> I tried if(A2:A20<>'yes',"alert") it doesnot work. it seems to check
> only the value of the cell in A20.
>
> Thanks in advance
> Amag
>