Support Board

Date/Time: Mon, 28 Oct 2024 08:57:29 +0000

Post From: Alert formula for color Background

[2023-09-17 23:57:45] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4100
I need assistance with an alert formula to color blue the background when the close is above the upper band and have the background remain the blue color until there is a close under the lower band. You need to create a persistent TRUE when the Close is > than the upper band, then release it when the Close is < the lower band. Reverse the operators for the opposite color. The TRUE, and the FALSE, are made persistent by referencing the color background's previous bar in the final 'else'. Blue: =IF(C>ID6.SG1,1,IF(C<ID7.SG1,0,ID8.SG1[-1])) where this color background study is ID8. Pink: =IF(C<ID7.SG1,1,IF(C>ID6.SG1,0,ID9.SG1[-1])) where this color background study is ID9. Date Time Of Last Edit: 2023-09-18 00:04:56