Login Page - Create Account

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
imageESH7 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