2007 Conditional Formatting Column Graph

Christiaan

Board Regular
Joined
Nov 5, 2012
Messages
80
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!
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,095,799
Messages
5,446,548
Members
405,406
Latest member
tuxy

This Week's Hot Topics

Top