Formating Color in Bar Chart based on cell values

C

Cesar

Hi,

How can I change the color of a Column Chart based on the values (limits)
of cell.
Assuming this,

A1 = Low Limit Value
A2 = High Limit Value
A3 = LowLow Limit Value
A4 = High High Limit Value
A5 = Actual Value

If A5 is between the A1 & A2 values the bar should be Green, if A5 is
outside the limits A1 & A2 but inside the limits A3 & A4, then the bar should
be Yellow and finally if A5 is out of the limits A3 & A4 the bar should be Red
Thanks

Cesar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

chart based on incremental difference 3
VBA Linest function for polynomial regression on horizontal range 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Return latest value from data range 4
Charting based on a specific month in a column 1
Graphing the maximum and minimum values 7
Remove specific cells in a column. 2
Using two Vlookup in one Cell 1

Top