Login Page - Create Account

Support Board


Date/Time: Mon, 16 Jun 2025 21:38:18 +0000



Post From: Help with syntax for (Color Background Based on Alert Condition).

[2022-09-19 16:32:51]
Sawtooth - Posts: 4227
You must create a persistent TRUE until the second condition, like this:
=IF (AND (ID2.SG2[-1]=ID1.SG2[-1], ID2.SG2=ID1.SG2, ID2.SG2>2, ID2.SG1=ID1.SG1=0), 1, IF ( ID2.SG2<1, 0, ID3.SG1[-1]))
where ID3 is the Color Background study.