View Single Post
  #1   Report Post  
Chris M
 
Posts: n/a
Default 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