Login Page - Create Account

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.