Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 10:52:26 +0000



Post From: color background in study

[2023-12-12 12:51:01]
Benz - Posts: 46
I have been trying to work around an alert formula that would look something like this:

=IF(ID1.SG53 > 1.0 * ID1.SG54 OR ID1.SG54 > 1.0 * ID1.SG53)

or this:

=IF(OR(ID1.SG53 > 1.0 * ID1.SG54, ID1.SG54 > 1.0 * ID1.SG53))

or at a more basic level:

=AND (ID1.SG53 > 1.0 * ID1.SG54)

I have been trying many different formula and study setting combinations using THESE STUDIES:

Color Background Based on Alert Condition
Color Bar Based on Alert Condition

I am having zero success.

Thanks