Christiaan
Board Regular
- Joined
- Nov 5, 2012
- Messages
- 81
Hello everyone!
I have a dynamic chart. Simple column graph. That's all working as expected. Now what I would like to do, is to color the column red if the score for that week is below X-value. Let's say 85%.
So, if the score for the week in cell B5:
>=$B$5 Green
<$B$5 Red
How can I do that easily? I know it can be done rather easily, but I am overlooking something here.
Any advice would be welcomed!
I have a dynamic chart. Simple column graph. That's all working as expected. Now what I would like to do, is to color the column red if the score for that week is below X-value. Let's say 85%.
So, if the score for the week in cell B5:
>=$B$5 Green
<$B$5 Red
How can I do that easily? I know it can be done rather easily, but I am overlooking something here.
Any advice would be welcomed!
