Login Page - Create Account

Support Board


Date/Time: Wed, 12 Feb 2025 14:56:29 +0000



Post From: Alert Settings

[2020-10-20 00:23:26]
Sawtooth - Posts: 4173
From your example, corrected for syntax:
=AND(ID2.SG1+ID2.SG2>0,CROSSFROMBELOW(ID1.SG1,ID1.SG2),ID8.SG1>ID8.SG1[-1])
This will color every bar when all 3 conditions are TRUE.

This is the basic format to color only the first bar when all 3 of the conditions are TRUE:
=OR(AND(A[-1]=0,A=1,B=1,C=1),AND(A=1,B[-1]=0,B=1,C=1),AND(A=1,B=1,C[-1]=0,C=1))
Notice that this has 3 sets of AND, where only one of the conditions in each goes TRUE, and the other two are already TRUE.