Support Board

Date/Time: Sun, 12 Jan 2025 18:45:02 +0000

[Programming Help] - color background alert with spreadsheet

[2017-03-02 23:25:00] #1 [Go To First Post]
joer - Posts: 41
I am trying to use the color background alert column in a spreadsheet calculation. When I replay the chart, I can see the correct background color on my chart and a corresponding "1" in the appropriate column in the spreadsheet. I have a formula that looks for 4 consecutive colored columns. I use if min(ad4:ad7)>0 to check for this condition. The problem is that formula sometimes returns a true result when there are only 3 consecutive colored bar backgrounds. In other words, I can look at the color background alert column and cells ad4 thru ad7 contain the values 0 1 1 1 yet the formula gives results as if the values were 1 1 1 1. This does not occur all the time, but I can see it when I replay the chart.

To post a message in this thread, you need to log in with your Sierra Chart account: