Support Board
Date/Time: Tue, 26 Nov 2024 08:34:38 +0000
Post From: "Color Bar Based on Alert Condition"- Feature Request
| [2023-12-28 02:03:42] |
| Ticks - Posts: 183 |
|
Just because it says spreadsheet formula. It does not mean you can only use a spreadsheet formula structure. It says this in the spreadsheet formula documentation. You can use the same if, and, or statements that are used in a color Bar Based on Alert Condition formula. IF(whatever value you need to be,ID1.SG1,0) As an example: In the screenshot, I showed you. This is the formula I used to get those number values. if( and( ID0.SG23[-2]> ID0.SG22[-2],ID2.SG7 > 0, (H[-1] - L ) / ticksize >=TICKSIZE*ID19.SG10 ),(H[-1] -L ) / ticksize, 0)
Date Time Of Last Edit: 2023-12-28 02:19:54
|