Support Board
Date/Time: Sun, 22 Dec 2024 05:00:01 +0000
Post From: SPREADSHEET BACKGROUND AND BAR COLOR CHANGES
| [2015-07-30 12:35:31] |
| Sawtooth - Posts: 4141 |
|
Well, I thought it would work, but I didn't test it. After some testing, there are two workarounds: 1) Use two instances of the spreadsheet study, each one with a unique name in the Spreadsheet Name field. 2) In addition to one spreadsheet study, use two instances of the Color Bar Based On Alert Condition study, set the Draw Style of one to Color Bar and the Draw Style of the other to Background, and use formulas in each one's Alerts tab like this: =ID1.SG1 =ID1.SG2 where ID1 is the spreadsheet study, and SG1/SG2 are the color bar/background formula columns. Both color bar studies must be below the spreadsheet study in the Studies to Graph list. |