Conditional Beep?

D

david1

david1 again
I did not explain my need well.
I can get beeps, but have still been unable to find a way to get the
as the result of a condition similar to the use of the conditiona
format
Countif($A$1:$A$100,$A1)>1 copied to each cell in Column A. Is ther
a way?

Thanks all for the responses.
davi
 
D

Dave Peterson

Take a look at John Walkenbach's site:
http://j-walk.com/ss/excel/tips/tip87.htm

But John has a note at how irritating this could be. (I don't think I use it
either.)

I'd put your =countif() in a separate cell and then use another helper cell:
=alarm(c2,">1")
(where c2 held the =countif() formula)
 
Top