Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 00:28:04 +0000
Post From: color bar based on alert condition
| [2013-05-02 16:13:15] |
| Sawtooth - Posts: 3993 |
|
Try this: Upslopes: =OR(AND(ID1.SG1>ID1.SG1[-1],ID1.SG1[-2]>ID1.SG1[-1],ID2.SG1>ID2.SG1[-1]),AND(ID2.SG1>ID2.SG1[-1],ID2.SG1[-2]>ID2.SG1[-1],ID1.SG1>ID1.SG1[-1])) Downslopes: =OR(AND(ID1.SG1<ID1.SG1[-1],ID1.SG1[-2]<ID1.SG1[-1],ID2.SG1<ID2.SG1[-1]),AND(ID2.SG1<ID2.SG1[-1],ID2.SG1[-2]<ID2.SG1[-1],ID1.SG1<ID1.SG1[-1])) Where ID1 and ID2 are the MAs. Edit as needed. |