Support Board
Date/Time: Mon, 19 May 2025 02:45:45 +0000
Post From: Study alert formula that triggers background Red, Blue, or nothing
| [2024-03-01 02:12:49] |
| cmet - Posts: 697 |
|
If you're looking to use the Color Bar Based on Alert Condition study, pretty sure you need to use two copies, one for the blue bg, one for the red. There is no syntax for the draw styles/colors (to my knowledge). To combine them into a single statement, use OR: =OR(AND(O<C[-1] , C>O[-4]), AND(C<O[-1] , O>C[-4])) |