This is a discussion on 2007 Conditional Formatting Column Graph within the Excel Questions forums, part of the Question Forums category; Hello everyone! I have a dynamic chart. Simple column graph. That's all working as expected. Now what I would like ...
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:
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!
This may help you Conditional Formatting of Excel Charts - Peltier Tech Blog
Please test any code on a copy of your workbook.