Automatic changing color in a chart

SPOT1

New Member
Joined
Jul 25, 2013
Messages
1
I would like to have Excel automaticly change the color of a bar graph.
So for example:
if the number is >80% show the bar in green.
if the number is between 50% and 80% show the bar in yellow
If below 50% in red.
WestEast
R1100%30%
R260%60%
R340%70%

<tbody>
</tbody>

How would a macro look like that once you change a number in this tabel changes the color of the bar automatic ?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,095,806
Messages
5,446,575
Members
405,409
Latest member
croc23

This Week's Hot Topics

Top