conditional formatting with FORMULA... Please HELP!
 

Hi all,

I have price data in rows like this (each price takes up a cell):
5 5.43 6 6.25 6.50 8 15 9.25 9 8.75 8.50 8.50 8.50
8.50 13

I need to show trends via conditional formatting where on 3 or more
consecutive days prices fluctuate EQUALLY by 0.25 or more each time, up or
down... IE, with the above data, I would want to "flag" let's say, in red
fill color, the sequence 6, 6.25, 6.50 as well as the group 9.25, 9, 8.75,
8.50, but NOT the group of 8.50, 8.50, 8.50.

I have tried if/and/or statements again and again and come close on simpler
trends, but can't get this one to work.

Here's my latest formula for the price in cell D2:
=OR((E2-D2=F2-E2)=0.25,(D2-C2=E2-D2)=0.25,(D2-C2=C2-B2)=0.25)

THANKS FOR YOUR HELP!!!
--
Chris M

Chris,

This seemed more complicated than it should have been...

I created a worksheet that does what you're asking, but used several
calculated rows below the price series, partly to demonstrate my logic,
and partly, because that's the only way I could figure it out!

See what you think.


+-------------------------------------------------------------------+
|Filename: For_Chris M.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3715 |
+-------------------------------------------------------------------+

--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=397044