Support Board
Date/Time: Mon, 25 Nov 2024 14:31:17 +0000
Post From: Study alert formula that triggers background Red, Blue, or nothing
| [2024-03-01 14:49:28] |
| Sawtooth - Posts: 4120 |
|
How to combine two strings into a single 'Color Bar Based on Alert Condition' study that triggers background 'Blue' to one, or 'Red' to the other, or nothing if neither?
You would need to use two instances of the color bar study, one for each color.However, if you want to only use one instance of a study for both colors, use the Spreadsheet Formula study with this formula in its Formula field: =IF(AND(O<C[-1] , C>O[-4]),1,IF(AND(C<O[-1] , O>C[-4]),-1,0)) - Set the Chart Region to 1 - Set the Draw Style to Color Bar - Set the Auto-Coloring to Based On +/- |