Forum Discussion
Conditional formatting in a clustered column chart
Sorry for misleading you, I did not understood the question at first.
You can do that, and here is how to do it step by step :
1 - Add the value you want to use as a color filter in the Color Saturation field
2 - Go to the Data Colors section in the Format area, it looks like that :
3 - Input the value as it follow :
Here I've put 999 999 as minima so that everything below is black and not half yellow half black
- Quentin
Thank you for your answer. Do you know of another way to solve the problem?
Solution Sage
Can you post here a screenshot of what you have at the moment ? It will help me trying to answer your question, I'm thinking about something but not sure about what you have
I may have mislead you
- Quentin
I want color all coulms that has a value above 1 m yellow
- quentin_vigne
Sorry for misleading you, I did not understood the question at first.
You can do that, and here is how to do it step by step :
1 - Add the value you want to use as a color filter in the Color Saturation field
2 - Go to the Data Colors section in the Format area, it looks like that :
3 - Input the value as it follow :
Here I've put 999 999 as minima so that everything below is black and not half yellow half black
- Quentin