Forum Discussion
Conditional Formatting of Bar Chart
I would like the bars that are below the target value to be red and those equal to or above target to be green. I do not see the 'divergent' color bar options .. do I have an old version of the app?...
Anonymous
How can we go if the target is variable ?
Currently there is no way to format the column based on a variable value. Conditional formatting will only work for a hard coded value (Min/Max value).
You can conditional format a column based on a wide range of values For example, if I set my min color to red and min value to -1, then any column that has a numerical value less than -1 will show up as red. Conversely, if I set my max color to green and my max value to 1, any column that has a value >1 will have a color of green. This is assuming I have my numerical column field in both the value well and the color saturation well.
