I am having trouble conditionally formatting the colors within my chart to display red for values below zero and green for values above zero. My questions are as follows:
1) My colors are displaying based on my conditional statement, however, I like the style 'Light Gradient.' However, I wish the green would display as the other colors, in a solid manner.
2) I would also like a split legend icon that represent two potential values for a single expression. For example, profit margin. If margins are below zero, it should be colored rgb(255,0,0), else rgb(0,255,0).