Support Board
Date/Time: Fri, 07 Feb 2025 21:19:52 +0000
Post From: color bar based on alert condition
[2013-05-02 16:13:15] |
Sawtooth - Posts: 4173 |
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. |