Trying to apply conditional formatting to bars in bar charts

[bhowerton]

Hello,

I have created an excel file that contains a lot of worksheets which contain a lot of raw data and charts. There are 5 different tabs for 5 different companies. Each tab currently contains only 1 year of raw data for that company. Then I have another excel worksheet that has nothing but charts on it. Each chart is a bar chart that shows each of the 5 companies. It also shows the current rate for the month for each company and the 12 month average for each company. On the chart there are also 3 lines. There is a standard line that we try to meet each month. There is also a line for the upper control limit and a line for the lower control limit.

Here is my problem:

The 2 bar charts (current rate for the month & the 12 month average) are created and updated by the raw data in each of the 5 data sheets.

Based upon the values in each of the cells that create and update the bars on the charts themselves:

I want the bars to be RED if the values are below the lower control limit.

And I want the bars to be GOLD if the values are above the upper control limit.

And I want the bars to be GREEN if the values are in between the upper and lower control limits.

How do I do this???

Please be detailed….

I have looked at the examples by http://peltiertech.com and I am very confused.

Any help on this problem would be greatly appreciated.

Bobby Howerton

[tain]

Try this guide:

http://www.cpearson.com/excel/cformatting.htm