There are probably fancier ways using the OFFSET function, but if you
could create formulas in the next column based on the IF function.

IF( AND (A10 < 0, A11 < 0, A12 < 0), do this, do that)

It looks like you are trying to find out how to get rich by predicting
stock price movements. Let us know if you figure it out.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=516647