Support Board
Date/Time: Sun, 12 Jan 2025 19:12:10 +0000
Post From: Background Coloring from Spreadsheet
| [2017-03-05 20:00:24] |
| JayShea - Posts: 92 |
|
Hello Was unable to find a solution in a review of 300+ posts with "Spreadsheet" in the search feature. I would like to color the chart background with a specific color (only two colors) if prompted by a signal (alert). Until there is a reverse signal, I want each subsequent chart space to have the same color background. Column K has a formula that says if value in column BI > 0, True, otherwise 0. No problem there. Column L has a formula that says if value in column BI > 0, True, otherwise 0. No problem there. I would like Column M to have the words "White" or "Brown" subject to the last signal (alert). The formula for Cell M3 that I wrote is: =IF(K3=True, "White", IF(L3=True, "Brown", M4)) Except for a small red triangle in the upper right corner of the cell, the formula provides no text and is blank. I hope there's a solution and it can help not only my formula writing but that of others as well. Thanks JD |