checking for values in a row

A

amitntu

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
 
R

Rowan Drummond

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

Regards
Rowan
 
Top