Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
Conditional Formatting based on Formula | Excel Worksheet Functions | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |