Support Board
Date/Time: Mon, 25 Nov 2024 14:35:17 +0000
Post From: Study alert formula that triggers background Red, Blue, or nothing
| [2024-03-01 02:12:49] |
| cmet - Posts: 551 |
|
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])) |