Support Board
Date/Time: Sun, 12 Jan 2025 19:10:52 +0000
Post From: Background Coloring from Spreadsheet
[2017-03-06 16:46:30] |
JayShea - Posts: 92 |
Dear Support Excellent start. Thank you. Attached is a chart. It shows my attempt to incorporate into two spreadsheet columns the formula you kindly suggested. The spreadsheet formulas are whether the yellow or black arrow has appeared in a cell. It is not a direct copy of your example. The yellow arrow at 7:00-AM indicates an uptrend and therefore I'd like that background to be colored (e.g. grey) as well as all following backgrounds the same color until a black down arrow (10:30-AM) reverses the trend and that background and all subsequent backgrounds are a new color (e.g. blue) until a yellow up-arrow appears. Looking at the attached chart, the black arrow appears, the background changes color to blue, the next background changes and then the backgrounds revert to grey instead of continuing as blue. I accept my own lack of articulation and will patiently explain my goals if the above is inadequate. Cheers JD |
ESH7 5 Min #1 2017-03-06 07_51_55.208.png / V - Attached On 2017-03-06 16:43:25 UTC - Size: 91.77 KB - 299 views |