Forum Discussion
Helper IHow to perform conditional formatting for clustered column chart
Through formatting I need to change the color of the chart into green or red,
My need-
1.In x-axis I have-LOS
y-axis I have-Bench_Percent_co. If the bench_Percent is below 85 means then the chart should be viewed in red color otherwise it should be in green color.
I implemented it through rules in Default color-column
but the color changes is not in a proper format
Here the Bench_percent_co is 63% so it should be in red color but the chart is in green color. Can you please help me to solve my problem. Thanks in advance
I checked all the ways to change the color in conditional formatting, after that I find out If I select to display only one bar chart then it always shows green color but when i didn't select anything it shows proper color(When I had group of charts). I think so it may be an issue.
5 Replies
Hi bhavadharani
in your second statement after the "and" you have still the number argument, try changing it to percent like in the first argument
Best Regards,
Daniel
bhavadharaniThanks a lot Anonymous
I changed the number argument as percent, Eventhough there is no changes. Can you please help me to solve the problem. Thanks in advance.
