Hello everyone! I currently want to enable users of a document to select the color that something appears without going into the conditional formatting settings. I’m using a relation to a table of colors to allow users to select the color that they would like the cell in question to appear, and the _Gradient formula allows me to use that selection to set the background color of another cell. So if a user selects “Green,” the background of the intended cell would be green. All’s well.
However, that doesn’t change the text color, and I quite like Coda’s light-green on dark-green, light-blue on dark-blue etc. formats. I can use the _color() function to take the value from another cell that is editable, and then the color from the dropdown I referenced above to color the text, but that means either my display column isn’t editable or isn’t colored. Is there any way to use the _color() formula like I’m using the gradient formula in conditional formatting to apply a color to text while leaving that text editable?
For reference, here’s the formula I’m using for the backgorund:
_GRADIENT(
thisRow.[Color ID],
1,
ParseJSON(‘{“colorId”: “White”, “shade”:“Light”}’),
2,
ParseJSON(‘{“colorId”: “White”, “shade”:“Light”}’),
3,
ParseJSON(‘{“colorId”: “White”, “shade”:“Light”}’),
4,
ParseJSON(‘{“colorId”: “White”, “shade”:“Light”}’),
5,
ParseJSON(‘{“colorId”: “White”, “shade”:“Light”}’),
6,
ParseJSON(‘{“colorId”: “White”, “shade”:“Light”}’),
7,
ParseJSON(‘{“colorId”: “White”, “shade”:“Light”}’),
8,
ParseJSON(‘{“colorId”: “White”, “shade”:“Light”}’),
9,
ParseJSON(‘{“colorId”: “Blue”, “shade”:“Light”}’),
10,
ParseJSON(‘{“colorId”: “Green”, “shade”:“Light”}’),
11,
ParseJSON(‘{“colorId”: “Yellow”, “shade”:“Light”}’),
12,
ParseJSON(‘{“colorId”: “Orange”, “shade”:“Light”}’),
13,
ParseJSON(‘{“colorId”: “Red”, “shade”:“Light”}’),
14,
ParseJSON(‘{“colorId”: “Pink”, “shade”:“Light”}’),
15,
ParseJSON(‘{“colorId”: “Purple”, “shade”:“Light”}’),
16,
ParseJSON(‘{“colorId”: “Gray”, “shade”:“Light”}’),
17,
ParseJSON(‘{“colorId”: “Blue”, “shade”:“Medium”}’),
18,
ParseJSON(‘{“colorId”: “Green”, “shade”:“Medium”}’),
19,
ParseJSON(‘{“colorId”: “Yellow”, “shade”:“Medium”}’),
20,
ParseJSON(‘{“colorId”: “Orange”, “shade”:“Medium”}’),
21,
ParseJSON(‘{“colorId”: “Red”, “shade”:“Medium”}’),
22,
ParseJSON(‘{“colorId”: “Pink”, “shade”:“Medium”}’),
23,
ParseJSON(‘{“colorId”: “Purple”, “shade”:“Medium”}’),
24,
ParseJSON(‘{“colorId”: “Gray”, “shade”:“Medium”}’),
25,
ParseJSON(‘{“colorId”: “Blue”, “shade”:“Dark”}’),
26,
ParseJSON(‘{“colorId”: “Green”, “shade”:“Dark”}’),
27,
ParseJSON(‘{“colorId”: “Yellow”, “shade”:“Dark”}’),
28,
ParseJSON(‘{“colorId”: “Orange”, “shade”:“Dark”}’),
29,
ParseJSON(‘{“colorId”: “Red”, “shade”:“Dark”}’),
30,
ParseJSON(‘{“colorId”: “Pink”, “shade”:“Dark”}’),
31,
ParseJSON(‘{“colorId”: “Purple”, “shade”:“Dark”}’),
32,
ParseJSON(‘{“colorId”: “Gray”, “shade”:“Dark”}’)
)