MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditionally formating a Column Chart


Posted by Tom Shoemaker on November 28, 2000 3:49 PM

Could someone please help with the creation of a macro that would look at the value for each column in a 12 column chart and set the interior color of the column base on the value. For example 100%-75% is green, 74%- 50% is yellow and less than 50% is red


Posted by Paul Butterfield on November 30, 2000 8:39 AM

Go to the Format..Conditional format menu and use a legend of cells for each format you wish. There is greater than and less than options for each formatting for the cells you want to format. is this clear?
Send me an e-mail if you need clarification.