Support Board

Date/Time: Thu, 02 May 2024 11:20:49 +0000

Post From: SPREADSHEET BACKGROUND AND BAR COLOR CHANGES

[2015-07-30 12:35:31] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3989
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.