Hi
see below

if my cell with the 10 day average was in H7 and my current volume
was
in F7 would this be the formula to compare two cell references...?

= Alarm (F7,"" & H7)

yes give this a try


Another question i have is what does BTW mean and how is this used in
the alarm function?

:-) just a shotcut for 'By the way'. I was just saying that this Alarm
function is not Excel standard but a user defined function published by
John Walkenbach (see http://j-walk.com/ss/excel/tips/tip87.htm)


Last question is how would I compare a number of stocks instead of
just
one row? Am i going to have to add this formula in for every stock
added in the spreadsheet or is there a quick and dirty method that
will
do it?
If your stocks are all stored in column F try the following
= Alarm (F7,"" & $H$7)
copy this down

Note: This can create quite a noise :-)