Support Board
Date/Time: Sun, 12 Jan 2025 18:29:30 +0000
Post From: color background alert with spreadsheet
| [2017-03-02 23:25:00] |
| 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.
|