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.
<tbody>
</tbody>
How would a macro look like that once you change a number in this tabel changes the color of the bar automatic ?
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.
West | East | |
R1 | 100% | 30% |
R2 | 60% | 60% |
R3 | 40% | 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 ?