checking for values in a row

  • Thread starter Thread starter amitntu
  • Start date Start date
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
 
One way (and I am sure there will be others <g>):
=IF(COUNTIF(A2:A20,"yes")<19,"Alert","")

Regards
Rowan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum number range ignoring numbers formatted as text 0
Populate cell with multiple non-blank text values 3
Count of Font Format 1
replacing values in Excel 3
How to synchronize all cell values? 1
Auto-fill the selected cells without using macro 3
Checking if a cell value in one range is contained in a second range? 4
i = row number of last occurance of duplicate string Column A 4

Back
Top