Support Board
Date/Time: Fri, 27 Dec 2024 11:33:48 +0000
Post From: color coded board
| [2015-05-31 17:49:12] |
| Sawtooth - Posts: 4143 |
|
This is the correct syntax, except it produces very few colored bars: =AND(CROSSOVER(ID5.SG1,ID5.SG2),ID5.SG1>0,C<ID1.SG1,C>ID3.SG1) However, you have given several disparate conditions so it's difficult to provide an exact formula. To be self-sufficient at writing formulas: -study the syntax examples at the link provided in post #7. -try a simplistic formula so that you can see success. -build the formula in steps to what your final alert conditions will be. -you'll need a separate instance of the Color Bar Based On Alert Condition study for each color. |