Support Board
Date/Time: Sat, 23 Nov 2024 22:19:51 +0000
Post From: user2user question regarding excel formula - not a technical SC issue.
| [2013-08-14 19:56:35] |
| Sawtooth - Posts: 4118 |
|
The Number of Formula Columns can be set to any value 16-60. (Warning: If you change it, you'll have to edit all of your formulas to reference different columns.) Here is a way to paint n bars with the first TRUE: Put this in S1: 20 This is the number of consecutive bars to paint from the first TRUE, inclusive. Put this in S3: =IF(OR(AND(E4<AA4,E3>AA3,S4>$S$1),AND(E3>AA3,S4=$S$1)),1,S4+1) This calculates when to start, and continue, counting bars since the first TRUE. Put this in T3: =IF(AND(S3>=1,S3<=$S$1),TRUE,FALSE) This is the column used to paint the bars when TRUE. Yes, this uses 2 columns to achieve your goal, but you have 60 possible. Date Time Of Last Edit: 2013-08-14 20:03:30
|